PANINT-8447 Users can now access and edit temporary chart filters. Previously, the temporary filters button would not show any filters if the chart had an error.

PANINT-7926 A new chart type has been added to list of available chart types. The variable width bar chart is very similar to a bar chart but allows a users to add two measures, users can then specify which measure determines the height of the bar and which determines the width.

Please refer to the Chart Types section in pi Documentation for more information.

SCHED-3 SMTP Server configuration now allows admin users to input an email address in cases where it differs from the username.

PANINT-8429 Each individual category object can now be set to be hidden.

• If a category object is set to hidden, it will not be displayed in the dashboard when viewing a category. However, it will still work as if this filter is on the category

• The hidden category objects will always use the default value or auto populated value, exactly as you’d expect to work when it’s not hidden

• If a category object is set to “must pre select”, meaning the user has to interact with this filter on the page, then this category object can’t be set to hidden

• The Slider category object type, which is a legacy implementation, does not support the hidden feature

PANINT-8116 This task is to implement report filters that work just like a category object filter.

• report filters should work exactly the same as category objects when the filters are applied to charts

• the filters should allow cascading and filtering from top to bottom exactly like category objects

• the filters should perform text replacement for placeholders that are put into the report - e.g. putting double curly brackets on Region will make Region a placeholder to be replaced by the value of an object called Region

• report filters should not be allowed to be set to hidden, because they always use the default values to set the filters and they don’t have a UI like category objects side panel to allow extra user interaction

• report filters should not support must_pre_select and hiding filter features (must pre select will prevent the report displaying charts, hiding is only for a UI that doesn’t exist)

• report filters do not support image, checkbox, and slider category object types (without an UI, images, checkboxes, and sliders are different variations of multi-select)

PANINT-7925 Two new chart types, Pie and Doughnut Variable Radius, are now available in the list of chart types. These are very similar to the standard Pie and Doughnut chart types but in addition they support two measures, the length of a segment is determined by one of the measures and the width is determined by the second measure. Please refer to the Chart Types section in pi Documentation for more information.

PANINT-8494 An option has been added to the Dashboard Configuration>- Settings screen that allows a user to schedule to an AWS S3 bucket. The instructions below for how to schedule to S3 assume you already have an S3 bucket created, and you have one of the following authentication configurations:

• IAM credentials (Access Key ID and Secret Access Key)

• A shared credentials file as shown at https://docs.aws.amazon.com/sdk-for-go/v1/developer-guide/configuring-sdk.html#specifying-credentials.

• A dashboard running on an EC2 instance with an appropriate role

PANINT-8439 The pi Reports module has been updated to include chart help text when a chart is added to a report, the chart help text will be displayed at the top of the report (beneath the chart title) when creating the report and also when previewing. In addition, when users hover over a chart that has been added to a report, the name of the chart is displayed.

PANINT-8535 Schedules were not being sent if multiple email addresses were added and each email address was not separated by a semicolon. Email addresses can now be separated by commas, semicolons, whitespace and newlines.

PANINT-8572 Fixed an issue for export and import, so that drill to URL for charts can be exported and imported correctly.

PANINT-8573 Fixed an issue for export and import, so that categories of a new connection to import are no longer displayed as items to add even when they exist in the target system.

PANINT-8445 Migrating from HyperSQL to MariaDB now works even without a licence.

PANINT-8501 API endpoint panMISDashboardWebServices/api/<token>/chart/ now returns all the charts a user has access to, this includes access being granted directly to the user and also to the user via a Role.

PANINT-8210 Fixed an issue where two charts may have the same UUID.

The duplication happened if you cloned a chart on a version before August 2019 and it would manifest itself by adding a chart to a report but the report would show a different chartChanges:

• Fixed duplicated uuids for charts, connections, objects.

• Updated chart level style and card chart type to use something else (id, hierarchy id and a time-sensitive seed) for style identity

  • this means it won’t get affected by UUID problems

  • this also covers an edge case where two instances of the same chart is present on the same category and one has its style changed

After upgrade:

• Check if your reports have the right charts in them

• Check charts with dynamic drills that depended on an Object

PANINT-8403 Map charts now correctly resize when opened in full screen. Previously, they were being displayed in full screen view in the same size as they appeared on the dashboard.

PANINT-8091 Fixed PostgreSQL and Freeform JDBC introspection. Freeform JDBC connections should now work for unknown JDBC drivers as long as they adhere to JDBC metadata standards.

PANINT-8099 Saving custom port numbers for Pirana (analytics) and Scheduler modules.

• Non default port numbers for the Scheduler and Pirana modules are no longer lost when upgrading a dashboard

• When installing the dashboard, users now have the option to choose if the Port Selector (admin tool) starts automatically after installing

• Excel Reader, Pirana and Scheduler now ship with .template files which provide a record of the default config settings for those modules. These files are not used by the software

PANINT-8454 Values on columns with ENUM type can now be previewed on Postgres data sources when editing a new object.

PANINT-8492 When two measures had been added to a Combined chart and measure 1 had a prefix of £ and measure 2 had a suffix of %, measure 2 was using the same prefix as measure 1. This has been fixed in the June release and now both measures will each display the correct prefix or suffix.

PANINT-8489 Fixed the order of listed values (e.g. filter value pickers). When an “ORDER BY” is defined on an object, the values of that object follow the specified order.

PANINT-8487 Fixed trend lines disappearing after using legend item filters. In this release, trend lines belonging to the visible measures will still be displayed while the others will be hidden as expected.

PANINT-8495 Combined charts no longer have extra empty space displayed at the top of the chart.

PANINT-7385 When a css tag has been specified to change the colour of the data labels, the specified colour was not displayed correctly in Sunburst and Doughnut Sunburst charts. This has been fixed in the June release.

PANINT-8502 The auto login mode on OpenID Connect authentication has been fixed in June release.

PANINT-8459 Whitelist and sanitize custom CSS used in themes, reports etc based on W3C list (Index of CSS properties ), CSS content outside the supported list will be dropped

PANINT-8460 Fixed CSRF vulnerability on user configuration.