Open

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

In Dashboard Configuration>Themes>Configuration a minimum Column Width and fixed Row Height has been added under the new heading ‘Tables’. These settings will apply to all table type charts (Table, Rotated Table and Editable Table) using the selected theme on the dashboard.

Adding a numerical value to ‘Minimum Column Width’ field will restrict all table columns so that they don’t fall below the specified width. This value will be respected even if width values have been applied to individual columns in the Edit Chart screen.

Adding a numerical value to ‘Row Height’ will fix the height of all table body rows to the specified height. Setting this value will also overwrite line-height in .pi-style__table-body-cell, to use this property the !important tag needs to be added to line-height in .pi-style__table-body-cell.

Open

Video

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

An option has been added that will provide users with the ability to style the Group Headers used in Crosstab tables. This will make it easier to distinguish between the different headers used. Group Headers can be styled using Dashboard Configuration > Themes > Style and then selecting the ‘Table’ tab.

Styles can be applied to the entire Group Header or alternatively, you can style headers that contain dates, numbers, text or null values separately using one of the other options available on the Themes>Styles>Tables tab. Please refer to the supporting documentation for more information.

Open

This is how the change made in the screenshot above would look on a table.

Open

Video

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

Network graph is a mathematical graph that shows relationships between points. The graph visualizes how subjects are interconnected with each other. Entities are displayed as nodes and the relationship between them is displayed as lines. The Network Graph has various uses such as to display relationships between people, companies, and products.

Screenshots

There is the option on the Network graph to display data in two different ways - grouped by Node or grouped by the State. The following example shows grouping by Node.

Open

Please refer to the related documentation for more information.

Video

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

A new chart type has been introduced which will allow users to combine up to 3 separate tables into one merged table, this feature works in a similar way to Merged Charts. Create and customise each table separately and when these tables are merged the Merged Table will inherit the individual features of the separate tables.

Screenshots

The following screenshots shows the result of a Crosstab table merged with a simple data table. Colouring has been added to each of the child tables and this has also been combined into the Merged table.

Open

Please refer to the related documentation for more information.

Video

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

New API endpoints have been added to allow for downloading charts. This works in the same way as clicking one of the download options in the Chart Tools menu on the dashboard.

If a user has the relevant permissions to download a chart in the dashboard, this user can also download the chart in the same format using the API.

The API returns the chart data content in text, so using the API to download a chart generally requires writing code to create the file with the data content.

You can find more information in our API documentation.