Open

We are pleased to present our latest offering of pi - our January 2021 release! This page helps summarise and familiarise you with the changes we have made, and is supported (where applicable) with useful videos to help explain the changes we have delivered.

Release Video

Here’s what we’ll cover;

Added

Description

Users will now be able to download charts, tables and reports as Word files (.docx).

A new icon has been added to both the Chart Tools menu and the pi Reports menu that will allow users to download charts and reports as Word documents. This is in addition to the currently available options of ‘Export to CSV’ and ‘Export to PDF’ for charts and ‘Generate PDF’ for pi Reports. To enable this feature for users, ensure that you click the ‘Export to Word’ option in the Users, Privileges section or User Access, Roles section in Dashboard Configuration.

Open

A new chart type, Waterfall, is now available and is available in either Horizontal or Vertical layouts. The standard Waterfall chart type is very similar to a Bar chart in appearance and the Horizontal Waterfall is similar to a Column chart.

Description

When help text is added to an object on the Dashboard Configuration-> Data Connection tab users will see the text when then hover over an object on the Edit Chart>- Data screen. By default, all objects will be displayed without help text. If you want to display help text, enter the text that you want users to see in the ‘Help Text’ field for the relevant object in Data Connections.

the help text will be displayed when a user hovers over the object in the dashboard.

Description

An additional option has been added to the System Variables section under Dashboard Configuration->Settings. This works in the same way as existing OpenID Connect functionality.

Description

Implemented filters for API GET requests that return multiple items (see detail)

The following operators are supported for the GET request * eq - equals to * gt - greater than * lt - less than * ge - greater than or equals to * le - less than or equals to * ne - not equals to * like - contains case insensitively * nlike - doesn’t contain, opposite to ‘like’URL parameters can be supplied in the following format: * fieldName(operator)=value * e.g. name(eq)=AndyExample: * http://localhost:8080/pi/api/v2/variables?name(like)=pi_&name(nlike)=logo * This should allow any variable with a name that contains ‘pi_’ and doesn’t contain ‘logo’

Description

Updated so that users API endpoint now includes a flag “passwordExpired”. When making a PUT request with “forceChangingPassword”, then “passwordExpired” is immediately set to true. Permission is automatically granted to all users with Chart Viewer or higher privileges.

Description

In Data Connections, a new option ‘Can Use In Temp Filter List of Values’, has been added to the Objects screen. This field is ticked by default, meaning that the the list of values will be visible in the Filter area of the dashboard.

If this option is unticked, the list of values in the selected object will not be available as a drop down list – users will instead be able to type free text into the filter field to find a value.

This has been implemented to prevent large lists appearing in drop-downs on the Filter screens.

Description

Updated so that super admin can use the API to delete a user that is in a broken state, (e.g. when the parentId of such a user is set to a non-existing user).

Changed

Description

Internal Refactor in Tooltips generation. 

• Now we do not use highcharts data to generate the tooltips, we create the tooltips based on our raw data.

• Separated each specific tooltip peer chart so we can have more control on the tooltips results.

•  

Description

API Authorization Header now allows more than one spaces between the keyword “bearer” or “basic” and the token. “bearer” or “basic” are now also case insensitive.

Fixed

Problem

Currently, when any of the following items are changed for a chart type:

• The chart type is changed e.g. from a bar chart to a column chart

• A data item is removed from the chart e.g. a measure

• A data item is changed e.g. a different object is selected

any colour options that have been applied to the chart were lost

Solution

This has been changed as follows:

• When a chart has both a Dimension and a Measure and both objects have new colours applied on the Colours tab in the Edit Chart screen, the chosen colours will be removed when the related Dimension or Measure is removed

  • The colours will be retained on the remaining object

• When a chart has both a Dimension and a Measure and both objects have new colours applied on the Colours tab in the Edit Chart screen, the chosen colours will be retained when the related Dimension or Measure is changed

• If a bar chart has been created and the chart type is changed to a Stacked Bar Chart, for example, any colours that were applied to the original chart will be retained in the new chart

Problem

When Admin level user accounts are disabled in Dashboard Configuration->Users, the number of disabled Admin user was still being counted in the licence usage count,

Solution

This has been fixed in this release and disabled Admin users will no longer be included in the licence usage count.

Decimals numbers were not being displayed in tooltip percentages on pie-charts.

This has been fixed in the January release.

Cumulation numbers were not showing the original value on tooltips

This has been fixed in the January release.

Problem

When the ‘Include Nulls’ option is ticked in the Chart Config screen, null values related to any of the data options were not being displayed on the chart.

Solution

Then filters will now have "OR IS NULL" appended:

When there is a limit on the number of displayed rows in a data connection and the logged in user does not have the ‘Can See Chart Warnings’ option ticked in their User Profile they will still be able to see the data in the chart.

When the ‘Can Allocate Filters’ box has been unticked for a Category in Dashboard Configuration

the category will not appear in the list when users are creating a filter in the Temp Filters screen.

Problem

When the ‘Can Use In Temp Filters’ option had been unticked for an Object in Data Connections, the object was still appearing in filter lists.

Solution

This has been fixed in this release and the object will no longer appear in filter lists.

Keeping An Eye On pi