Empty and zero values in Visual Reports | Targetprocess - Visual management software

Empty and zero values in Visual Reports

Multiple charts in Visual Reports for Targetprocess are based on numeric data. This article describes how empty and zero values are displayed on the charts. Format used for CSV export is also specified here.

Source Data

Source Data view displays raw data extracted from the entities. Browse Actions > Browse data > Source data menu item to access it.

Source Data

Zero values are displayed as 0 in the data grid. For many built-in numeric fields Targetprocess provides zero values as default ones.

Empty, missing, and undefined values are displayed as blank cells in the data grid.

Same rules are applied when you export the Source Data to a CSV file.

Chart Data

Chart Data view displays data used in chart dimensions. Browse Actions > Browse data > Chart data menu item to access it.

Chart Data

Format of numbers displayed on the chart depends on the Group mode selected in axis settings. Same rules are applied when you export the Chart Data to a CSV file or when you select Actions > Export to CSV menu item.

No grouping

No grouping

In this mode the chart interprets any numeric field value as number. Empty, missing, and undefined values are replaced with zeros.

No grouping. Image 4

We perform this transformation in order to display all data on the chart. Otherwise empty data points would be excluded from the chart which could be confusing for viewers.

Intervals grouping

Intervals grouping

In this mode the chart is able to split empty values from numbers. Data with empty, missing, and undefined values are displayed under a separate No Value group.

Intervals grouping. Image 6

Still have a question?

We're here to help! Just contact our friendly support team

Find out more about our APIs, Plugins, Mashups and custom extensions. Join our community of passionate users and even discuss directly with our developers.