Open

We are pleased to present our latest offering of pi - our May 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;

Added

Fields for Catalog Name and Schema Name have been added to the Import Manual Data Table and to Data Table Details. This allows users to see and edit these fields manually.

Open

If these fields are not correct the system would not be able to get a list of columns of this table. The correct value is set at the time this table is imported using the table import tool.

Open

• Catelog Name - This is set when creating a new table. If the field is empty, you can use the table import tool to import a new table and find out what this is

• Schema Name - This is set when creating a new table, and will generally be prefixed on the table name

The text ‘Total’ now appears on the first column of a table if that column doesn’t have a total already configured (for example, if the last column is numeric and has a Sum total). Please have a look at this section for more information.

Open

If required, the text can be customised by changing the ‘Alternate Column Total Title’ field on the ‘Attributes’ screen.

Open

As before, if no columns have a total configured, the total row does not appear and therefore neither does the total text.

Video

We’ve created a short video to explain this in a bit more detail.

Added API endpoints to allow directly getting columns without providing connection id, which includes:

GET /columns

GET /columns/{id}

In the ‘Edit Chart’ screen, you can now disable the warning message that normally appears when a user clicks on an undefined drill condition.

To disable this message, select the drill level in the ‘Edit Chart’ screen and untick the box on the ‘Data’ tab. By default, the checkbox will be ticked on new drill to levels. You can find full information in this section.

Open

The following screenshot shows how the message will be displayed if the box is ticked.

Open

Video

We’ve created a short video to explain this in a bit more detail.

When drilling from a chart to a category using the Drill to Category feature, filters will be passed to the destination category, just like how a normal drill down works. The destination category must have Category Objects enabled, the passed filters are then used to fill in these Category Objects.

Please see this section in pi Documentation for more information.

Video

We’ve created a short video to explain this in a bit more detail.

A new chart type, Chord Diagram, has been added to the list of available chart types. A Chord Diagram is a chart type that’s used to display the flow of data from one node to another in a multidirectional representation. The things being connected are referred to as nodes, in our diagram below the nodes are ‘Employee Names’, and the lines running from one node to another are referred to as links (or Arcs). The thickness of a link is proportional to the amount of data it represents, the thickest line in our example runs from Leah to Jon and from this we can see that the largest number of tickets connect these two employees. You can also create drill down levels from a Chord Diagram, please refer to the supporting documentation for more information.

Screenshots

The following screenshot shows the general view of a Chord Diagram i.e. displaying all links.

Open

Please see this section in pi Documentation for more information on creating, formatting and using Chord Diagrams.