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.

Here’s what we’ll cover;

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.

Open

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.

Open

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

Open

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.

Open

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.

Open

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.

Open

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