Skip to main content
Version: 1.20.1

Report Types

Bar

Bar reports display categorized data in the form of vertical bars whose length is proportional to the data values. Group bars to make the chart representation visual and clear.

This report view is useful for dividing data into categories and comparing them.

Setting parameters
FieldMandatoryDescription
Group byYSelect table columns as criteria for data grouping.
Slice byNSelect a table column as a slice criterion and configure a Slice type.
Slice typeNSelect the type of data slice:
  • Grouped – to group the bars in one heap.
  • Stacked – to vertically stack the bars on each other.
The Slice type field appears if the Slice by option is specified.
Add data tableNSelect this checkbox to display the data table below your report view.
Aggregation typeNSelect the data aggregation to create combined datasets for data processing. Available options:
  • Average – counts an average number of the column values.
  • Count – counts the number of records in the specified table on the Data tab.
  • Count distinct – counts the number of unique values of the column.
  • Sum – counts the sum of the numeric data values in this table column.
The Sum and Average settings make sense if the aggregation column keeps the numeric data.

When this aggregation option is selected, it is applied to the table column set in the Aggregation column field.

Aggregation columnYSelect a table column with numeric values for data aggregation.

The Aggregation column field is available only if the Aggregation type option is set to one of the following: Average, Count distinct, Sum.

Groups limitNSet the limit of the data groups shown in your report with a particular number in this field.
Show rest as otherNSelect this checkbox to show the data groups not included in Groups limit as one.

The Show rest as other field is available only if the Groups limit option is specified.

Pie

Pie reports display data in the form of a circular graph divided into slices. Each slice proportionally displays a particular data category.

This report view is useful for comparing the proportions of individual values to the whole. The pie chart is the most obvious choice when the number of categories is small.

Setting parameters
FieldMandatoryDescription
Group byYSelect table columns as criteria for data grouping.
Add data tableNSelect this checkbox to display the data table below your report view.
Aggregation typeNSelect the data aggregation to create combined datasets for data processing. Available options:
  • Average – counts an average number of the column values.
  • Count – counts the number of records in the specified table on the Data tab.
  • Count distinct – counts the number of unique values of the column.
  • Sum – counts the sum of the numeric data values in this table column.
The Sum and Average settings make sense if the aggregation column keeps the numeric data.

When this aggregation option is selected, it is applied to the table column set in the Aggregation column field.

Aggregation columnYSelect a table column with numeric values for data aggregation.

The Aggregation column field is available only if the Aggregation type option is set to one of the following: Average, Count distinct, Sum.

Groups limitNSet the limit of the data groups shown in your report with a particular number in this field.
Show rest as otherNSelect this checkbox to show the data groups not included in Groups limit as one.

The Show rest as other field is available only if the Groups limit option is specified.

Gauge

Gauge reports present a single metric value from the data via the gauge panel with a dial on it.

This report view is useful for evaluating the criticality according to the established limits.

Setting parameters
FieldMandatoryDescription
Aggregation typeNSelect the data aggregation to create combined datasets for data processing. Available options:
  • Average – counts an average number of the column values.
  • Count – counts the number of records in the specified table on the Data tab.
  • Count distinct – counts the number of unique values of the column.
  • Sum – counts the sum of the numeric data values in this table column.
The Sum and Average settings make sense if the aggregation column keeps the numeric data.

When this aggregation option is selected, it is applied to the table column set in the Aggregation column field.

Aggregation columnYSelect a table column with numeric values for data aggregation.

The Aggregation column field is available only if the Aggregation type option is set to one of the following: Average, Count distinct, Sum.

Maximum valueNDefine the maximum value for the data set as the Aggregation column.
Minimum valueNDefine the minimum value for the data set as the Aggregation column.

Digit

Digit reports provide a simple digit representation of a single metric value.

This report view is useful for monitoring the critical parameters by using a clear visual presentation.

Setting parameters
FieldMandatoryDescription
Aggregation typeNSelect the data aggregation to create combined datasets for data processing. Available options:
  • Average – counts an average number of the column values.
  • Count – counts the number of records in the specified table on the Data tab.
  • Count distinct – counts the number of unique values of the column.
  • Sum – counts the sum of the numeric data values in this table column.
The Sum and Average settings make sense if the aggregation column keeps the numeric data.

When this aggregation option is selected, it is applied to the table column set in the Aggregation column field.

Aggregation columnYSelect a table column with numeric values for data aggregation.

The Aggregation column field is available only if the Aggregation type option is set to one of the following: Average, Count distinct, Sum.

Line

Line reports present data as a graph of points connected by a line and visualize the metric data values.

This report view is useful for comparing data per time period (years, months, and other).

Setting parameters
FieldMandatoryDescription
Trend byYSelect the table column of the Date/Time type to use it as a timeline period.
Group byYSelect table columns as criteria for data grouping.
PerNSelect a period as a grouping criterion. Available options:
  • Year
  • Quarter
  • Month
  • Week
  • Day
  • Hour
  • Date
Combine preiodsNSelect this checkbox to combine data changes over the same period. 
Add data tableNSelect this checkbox to display the data table below your report view.
Aggregation typeNSelect the data aggregation to create combined datasets for data processing. Available options:
  • Average – counts an average number of the column values.
  • Count – counts the number of records in the specified table on the Data tab.
  • Count distinct – counts the number of unique values of the column.
  • Sum – counts the sum of the numeric data values in this table column.
The Sum and Average settings make sense if the aggregation column keeps the numeric data.

When this aggregation option is selected, it is applied to the table column set in the Aggregation column field.

Aggregation columnYSelect a table column with numeric values for data aggregation.

The Aggregation column field is available only if the Aggregation type option is set to one of the following: Average, Count distinct, Sum.

Groups limitNSet the limit of the data groups shown in your report with a particular number in this field.The field appears when the Group by field is filled in.
Show rest as otherNSelect this checkbox to show the data groups not included in Groups limit as one.

The Show rest as other field is available only if the Groups limit option is specified.

Trend

Trend reports show the dynamics of data changes. The data is presented in the form of columns divided by periods of time. This report type is useful for monitoring time parameters.

Setting parameters
FieldMandatoryDescription
Trend byYSelect the table column of the Date/Time type to use it as a timeline parameter you want to monitor.
Group byYSelect table columns as criteria for data grouping.
PerNSelect a period as a grouping criterion. Available options:
  • Year
  • Quarter
  • Month
  • Week
  • Day
  • Hour
  • Date
Combine preiodsNSelect this checkbox to combine data changes over the same period. 
Add data tableNSelect this checkbox to display the data table below your report view.
Aggregation typeNSelect the data aggregation to create combined datasets for data processing. Available options:
  • Average – counts an average number of the column values.
  • Count – counts the number of records in the specified table on the Data tab.
  • Count distinct – counts the number of unique values of the column.
  • Sum – counts the sum of the numeric data values in this table column.
The Sum and Average settings make sense if the aggregation column keeps the numeric data.

When this aggregation option is selected, it is applied to the table column set in the Aggregation column field.

Aggregation columnYSelect a table column with numeric values for data aggregation.

The Aggregation column field is available only if the Aggregation type option is set to one of the following: Average, Count distinct, Sum.

Groups limitNSet the limit of the data groups shown in your report with a particular number in this field.The field appears when the Group by field is filled in.
Show rest as otherNSelect this checkbox to show the data groups not included in Groups limit as one.

The Show rest as other field is available only if the Groups limit option is specified.

List

List reports represent table data in the form of a list view.

Setting parameters
FieldMandatoryDescription
List viewYSelect a list view for a report with one of the list layouts configured.
Items limitYDefine a limit of the table items used as a source for the report.
Display all itemsNSelect this checkbox to display all table items used for report configuration. When the checkbox is selected, the Items limit field is hidden.

Pivot Table

Pivot reports present your data in the form of a view. The data is analyzed, aggregated, and grouped based on two metrics (as rows and columns).

This report view is useful for comparing, summarizing, and counting a large amount of data.

Setting parameters

Setting parameters
FieldMandatoryDescription
ColumnYSet the desired table column as a column for the pivot table report.
RowYSet the desired table column as a row for the pivot table report.
Aggregation typeNSelect the data aggregation to create combined datasets for data processing. Available options:
  • Average – counts an average number of the column values.
  • Count – counts the number of records in the specified table on the Data tab.
  • Count distinct – counts the number of unique values of the column.
  • Sum – counts the sum of the numeric data values in this table column.
The Sum and Average settings make sense if the aggregation column keeps the numeric data.

When this aggregation option is selected, it is applied to the table column set in the Aggregation column field.

Aggregation columnYSelect a table column with numeric values for data aggregation.

The Aggregation column field is available only if the Aggregation type option is set to one of the following: Average, Count distinct, Sum.

Groups limitNSet the limit of the data groups shown in your report with a particular number in this field.The field appears when the Group by field is filled in.
Show rest as otherNSelect this checkbox to show the data groups not included in Groups limit as one.

The Show rest as other field is available only if the Groups limit option is specified.

Heatmap

Heatmap reports display your data as the intersection of two metrics in a table with colored cells. These cells contain data values visualized with different color shades.

Setting parameters
FieldMandatoryDescription
ColumnYSet the desired table column as a column for the heatmap report.
RowYSet the desired table column as a row for the heatmap report.
Aggregation typeNSelect the data aggregation to create combined datasets for data processing. Available options:
  • Average – counts an average number of the column values.
  • Count – counts the number of records in the specified table on the Data tab.
  • Count distinct – counts the number of unique values of the column.
  • Sum – counts the sum of the numeric data values in this table column.
The Sum and Average settings make sense if the aggregation column keeps the numeric data.

When this aggregation option is selected, it is applied to the table column set in the Aggregation column field.

Aggregation columnYSelect a table column with numeric values for data aggregation.

The Aggregation column field is available only if the Aggregation type option is set to one of the following: Average, Count distinct, Sum.

Groups limitNSet the limit of the data groups shown in your report with a particular number in this field.The field appears when the Group by field is filled in.
Show rest as otherNSelect this checkbox to show the data groups not included in Groups limit as one.

The Show rest as other field is available only if the Groups limit option is specified.

Multilevel Pivot Table

Multilevel Pivot Tables reports represent your data in the form a table view. The data is aggregated, grouped, and analyzed based on two metrics (as rows and columns).

This report view is extremely useful for comparing, summarizing, and counting a large amount of data.

Setting parameters
FieldMandatoryDescription
ColumnsYDefine desired table columns as a data source for the multilevel pivot table report columns.
RowsYDefine desired table columns as a data source for the multilevel pivot table report rows.
Aggregation typeNSelect the data aggregation to create combined datasets for data processing. Available options:
  • Average – counts an average number of the column values.
  • Count – counts the number of records in the specified table on the Data tab.
  • Count distinct – counts the number of unique values of the column.
  • Sum – counts the sum of the numeric data values in this table column.
The Sum and Average settings make sense if the aggregation column keeps the numeric data.

When this aggregation option is selected, it is applied to the table column set in the Aggregation column field.

Aggregation columnYSelect a table column with numeric values for data aggregation.

The Aggregation column field is available only if the Aggregation type option is set to one of the following: Average, Count distinct, Sum.

Groups limitNSet the limit of the data groups shown in your report with a particular number in this field.The field appears when the Group by field is filled in.
Show rest as otherNSelect this checkbox to show the data groups not included in Groups limit as one.

The Show rest as other field is available only if the Groups limit option is specified.