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
- Configure
- General Style
- Title Style
- X Style
- Y Style
Field | Mandatory | Description |
---|---|---|
Group by | Y | Select table columns as criteria for data grouping. |
Slice by | N | Select a table column as a slice criterion and configure a Slice type. |
Slice type | N | Select the type of data slice:
|
Add data table | N | Select this checkbox to display the data table below your report view. |
Aggregation type | N | Select the data aggregation to create combined datasets for data processing. Available options:
When this aggregation option is selected, it is applied to the table column set in the Aggregation column field. |
Aggregation column | Y | Select 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 limit | N | Set the limit of the data groups shown in your report with a particular number in this field. |
Show rest as other | N | Select 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. |
Field | Mandatory | Description |
---|---|---|
Chart color type | N | Select the color type of your bar chart:
|
Color | N | Set the color for your bar chart if you selected Use one color as the color type. Click the magnifier icon to select one of the available colors. |
Palette | N | Set the desired color palette for your bar chart if you selected Use color palette as the color type. Click the magnifier icon to select one of the available palettes. |
Display data labels | N | Select this checkbox to display data labels on your bar chart. |
Drilldown list layout | N | Use this option to configure the view of the data slice drilled down. Click the magnifier icon to select a list view of the source table. See Lists if you want to configure the list view. |
Decimal precision | N | Define how many numbers should be displayed after the point of numeric data values in your chart. This field appears when the Aggregation type field on the Configure tab contains Sum or Average. |
Field | Mandatory | Description |
---|---|---|
Report title show type | N | Select the type for the report title showing. Available options:
|
Report title | N | Specify the title of the report. |
Report title size | N | Specify the number of pixels to set the size of the report title. |
Report title color | N | Select the color of the report title. Click the magnifier icon to select one of the available colors. |
Title alignment | N | Set the alignment of the report title. Available options:
|
Bold title | N | Select this checkbox to make the report title bold. |
Field | Mandatory | Description |
---|---|---|
X title | N | Specify the title name for the X-axis for your chart. |
X title size | N | Define the number of pixels to set the size for the title of the X-axis. |
X title bold | N | Select this checkbox to make the title of the X-axis bold. |
X display opposite | N | Select this checkbox to make the X-axis display opposite. |
X display grid | N | Select this checkbox to display the grid of the X-axis. |
X grid dotted | N | Select this checkbox to make the X-axis grid dotted. Use this checkbox with the X display grid field selected. |
X label size | N | Define the number of pixels to set the size of the X label. |
Field | Mandatory | Description |
---|---|---|
Y title | N | Specify the title name for the Y-axis for your chart. |
Y title size | N | Define the number of pixels to set the size for the title of the Y-axis. |
Y title bold | N | Select this checkbox to make the title of the Y-axis bold. |
Y display opposite | N | Select this checkbox to make the Y-axis display opposite. |
Y Display grid | N | Select this checkbox to display the grid of the Y-axis. |
Y grid dotted | N | Select this checkbox to make the Y-axis grid dotted. Use this checkbox with the Y display grid field selected. |
Y from | N | Set the Y value used as the chart starting point. |
Y to | N | Set the Y value used as the chart endpoint. |
Y label size | N | Define the number of pixels to set the size of the Y label. |
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
- Configure
- General Style
- Title Style
- Legend Style
Field | Mandatory | Description |
---|---|---|
Group by | Y | Select table columns as criteria for data grouping. |
Add data table | N | Select this checkbox to display the data table below your report view. |
Aggregation type | N | Select the data aggregation to create combined datasets for data processing. Available options:
When this aggregation option is selected, it is applied to the table column set in the Aggregation column field. |
Aggregation column | Y | Select 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 limit | N | Set the limit of the data groups shown in your report with a particular number in this field. |
Show rest as other | N | Select 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. |
Field | Mandatory | Description |
---|---|---|
Chart color type | N | Select the color type of your chart:
|
Color | N | Set the color for your chart if you selected Use one color as the color type. Click the magnifier icon to select one of the available colors. |
Palette | N | Set the desired color palette for your pie chart if you selected Use color palette as the color type. Click the magnifier icon to select one of the available palettes. |
Display data labels | N | Select this checkbox to display data labels on your pie chart. |
Drilldown list layout | N | Use this option to configure the view of the data slice drilled down. Click the magnifier icon to select a list view of the source table. See Lists if you want to configure the list view. |
Decimal precision | N | Define how many numbers should be displayed after the point of numeric data values in your chart. This field appears when the Aggregation type field on the Configure tab contains Sum or Average. |
Field | Mandatory | Description |
---|---|---|
Report title show type | N | Select the type for the report title showing. Available options:
|
Report title | N | Specify the title of the report. |
Report title size | N | Specify the number of pixels to set the size of the report title. |
Report title color | N | Select the color of the report title. Click the magnifier icon to select one of the available colors. |
Title alignment | N | Set the alignment of the report title. Available options:
|
Bold title | N | Select this checkbox to make the report title bold. |
Field | Mandatory | Description |
---|---|---|
Show legend | N | Select this checkbox to display the chart legend. |
Legend alignment | N | Set the alignment of the chart legend. Available options:
|
Show ledgend border | N | Select this checkbox to display the border of your chart legend. |
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
- Configure
- General Style
- Title Style
Field | Mandatory | Description |
---|---|---|
Aggregation type | N | Select the data aggregation to create combined datasets for data processing. Available options:
When this aggregation option is selected, it is applied to the table column set in the Aggregation column field. |
Aggregation column | Y | Select 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 value | N | Define the maximum value for the data set as the Aggregation column. |
Minimum value | N | Define the minimum value for the data set as the Aggregation column. |
Field | Mandatory | Description |
---|---|---|
Chart color | N | Select the color type of your report chart:
|
Color | N | Set the color for your gauge report if you selected Use one color as the color type. Click the magnifier icon to select one of the available colors. |
Lower limit | N | Enter the lower limit value for the gauge report metric. All data values below this limit are considered low scores and are painted in Low score color. |
Upper limit | N | Enter the upper limit value for the gauge report metric. All data values below this limit are considered middle scores and painted in Middle score color. |
Low score color | N | Set the color for values below the Lower limit. |
Middle score color | N | Set the color for values below the Upper limit and above the Lower limit. |
High score color | N | Set the color for values above the Upper limit. |
Drilldown list layout | N | Use this option to configure the view of the data slice drilled down. Click the magnifier icon to select a list view of the source table. See Lists if you want to configure the list view. |
Decimal precision | N | Define how many numbers should be displayed after the point of numeric data values in your chart. This field appears when the Aggregation type field on the Configure tab contains Sum or Average. |
Field | Mandatory | Description |
---|---|---|
Report title show type | N | Select the type for the report title showing. Available options:
|
Report title | N | Specify the title of the report. |
Report title size | N | Specify the number of pixels to set the size of the report title. |
Report title color | N | Select the color of the report title. Click the magnifier icon to select one of the available colors. |
Title alignment | N | Set the alignment of the report title. Available options:
|
Bold title | N | Select this checkbox to make the report title bold. |
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
- Configure
- General Style
- Title Style
Field | Mandatory | Description |
---|---|---|
Aggregation type | N | Select the data aggregation to create combined datasets for data processing. Available options:
When this aggregation option is selected, it is applied to the table column set in the Aggregation column field. |
Aggregation column | Y | Select 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. |
Field | Mandatory | Description |
---|---|---|
Drilldown list layout | N | Use this option to configure the view of the data slice drilled down. Click the magnifier icon to select a list view of the source table. See Lists if you want to configure the list view. |
Decimal precision | N | Define how many numbers should be displayed after the point of numeric data values in your chart. This field appears when the Aggregation type field on the Configure tab contains Sum or Average. |
Color | N | Set the color for your digit chart. Click the magnifier icon to select one of the available colors. |
Field | Mandatory | Description |
---|---|---|
Report title show type | N | Select the type for the report title showing. Available options:
|
Report title | N | Specify the title of the report. |
Report title size | N | Specify the number of pixels to set the size of the report title. |
Report title color | N | Select the color of the report title. Click the magnifier icon to select one of the available colors. |
Title alignment | N | Set the alignment of the report title. Available options:
|
Bold title | N | Select this checkbox to make the report title bold. |
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
- Configure
- General Style
- Title Style
- X Style
- Y Style
- Legend Style
Field | Mandatory | Description |
---|---|---|
Trend by | Y | Select the table column of the Date/Time type to use it as a timeline period. |
Group by | Y | Select table columns as criteria for data grouping. |
Per | N | Select a period as a grouping criterion. Available options:
|
Combine preiods | N | Select this checkbox to combine data changes over the same period. |
Add data table | N | Select this checkbox to display the data table below your report view. |
Aggregation type | N | Select the data aggregation to create combined datasets for data processing. Available options:
When this aggregation option is selected, it is applied to the table column set in the Aggregation column field. |
Aggregation column | Y | Select 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 limit | N | Set 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 other | N | Select 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. |
Field | Mandatory | Description |
---|---|---|
Chart color type | N | Select the color type of your line chart:
|
Color | N | Set the color for your line chart if you selected Use one color as the color type. Click the magnifier icon to select one of the available colors. |
Palette | N | Set the desired color palette for your line chart if you selected Use color palette as the color type. Click the magnifier icon to select one of the available palettes. |
Display data labels | N | Select this checkbox to display data labels on your line chart. |
Drilldown list layout | N | Use this option to configure the view of the data slice drilled down. Click the magnifier icon to select a list view of the source table. See Lists if you want to configure the list view. |
Decimal precision | N | Define how many numbers should be displayed after the point of numeric data values in your chart. This field appears when the Aggregation type field on the Configure tab contains Sum or Average. |
Field | Mandatory | Description |
---|---|---|
Report title show type | N | Select the type for the report title showing. Available options:
|
Report title | N | Specify the title of the report. |
Report title size | N | Specify the number of pixels to set the size of the report title. |
Report title color | N | Select the color of the report title. Click the magnifier icon to select one of the available colors. |
Title alignment | N | Set the alignment of the report title. Available options:
|
Bold title | N | Select this checkbox to make the report title bold. |
Field | Mandatory | Description |
---|---|---|
X title | N | Specify the title name for the X-axis for your chart. |
X title size | N | Define the number of pixels to set the size for the title of the X-axis. |
X title bold | N | Select this checkbox to make the title of the X-axis bold. |
X display opposite | N | Select this checkbox to make the X-axis display opposite. |
X display grid | N | Select this checkbox to display the grid of the X-axis. |
X grid dotted | N | Select this checkbox to make the X-axis grid dotted. Use this checkbox with the X display grid field selected. |
X label size | N | Define the number of pixels to set the size of the X label. |
Field | Mandatory | Description |
---|---|---|
Y title | N | Specify the title name for the Y-axis for your chart. |
Y title size | N | Define the number of pixels to set the size for the title of the Y-axis. |
Y title bold | N | Select this checkbox to make the title of the Y-axis bold. |
Y display opposite | N | Select this checkbox to make the Y-axis display opposite. |
Y Display grid | N | Select this checkbox to display the grid of the Y-axis. |
Y grid dotted | N | Select this checkbox to make the Y-axis grid dotted. Use this checkbox with the Y display grid field selected. |
Y from | N | Set the Y value used as the chart starting point. |
Y to | N | Set the Y value used as the chart endpoint. |
Y label size | N | Define the number of pixels to set the size of the Y label. |
Field | Mandatory | Description |
---|---|---|
Show legend | N | Select this checkbox to display the chart legend. |
Legend alignment | N | Set the alignment of the chart legend. Available options:
|
Show ledgend border | N | Select this checkbox to display the border of your chart legend. |
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
- Configure
- General Style
- Title Style
- X Style
- Y Style
Field | Mandatory | Description |
---|---|---|
Trend by | Y | Select the table column of the Date/Time type to use it as a timeline parameter you want to monitor. |
Group by | Y | Select table columns as criteria for data grouping. |
Per | N | Select a period as a grouping criterion. Available options:
|
Combine preiods | N | Select this checkbox to combine data changes over the same period. |
Add data table | N | Select this checkbox to display the data table below your report view. |
Aggregation type | N | Select the data aggregation to create combined datasets for data processing. Available options:
When this aggregation option is selected, it is applied to the table column set in the Aggregation column field. |
Aggregation column | Y | Select 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 limit | N | Set 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 other | N | Select 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. |
Field | Mandatory | Description |
---|---|---|
Chart color type | N | Select the color type of your trend chart:
|
Color | N | Set the color for your trend chart if you selected Use one color as the color type. Click the magnifier icon to select one of the available colors. |
Palette | N | Set the desired color palette for your trend chart if you selected Use color palette as the color type. Click the magnifier icon to select one of the available palettes. |
Display data labels | N | Select this checkbox to display data labels on your trend chart. |
Drilldown list layout | N | Use this option to configure the view of the data slice drilled down. Click the magnifier icon to select a list view of the source table. See Lists if you want to configure the list view. |
Decimal precision | N | Define how many numbers should be displayed after the point of numeric data values in your chart. This field appears when the Aggregation type field on the Configure tab contains Sum or Average. |
Field | Mandatory | Description |
---|---|---|
Report title show type | N | Select the type for the report title showing. Available options:
|
Report title | N | Specify the title of the report. |
Report title size | N | Specify the number of pixels to set the size of the report title. |
Report title color | N | Select the color of the report title. Click the magnifier icon to select one of the available colors. |
Title alignment | N | Set the alignment of the report title. Available options:
|
Bold title | N | Select this checkbox to make the report title bold. |
Field | Mandatory | Description |
---|---|---|
X title | N | Specify the title name for the X-axis for your chart. |
X title size | N | Define the number of pixels to set the size for the title of the X-axis. |
X title bold | N | Select this checkbox to make the title of the X-axis bold. |
X display opposite | N | Select this checkbox to make the X-axis display opposite. |
X display grid | N | Select this checkbox to display the grid of the X-axis. |
X grid dotted | N | Select this checkbox to make the X-axis grid dotted. Use this checkbox with the X display grid field selected. |
X label size | N | Define the number of pixels to set the size of the X label. |
Field | Mandatory | Description |
---|---|---|
Y title | N | Specify the title name for the Y-axis for your chart. |
Y title size | N | Define the number of pixels to set the size for the title of the Y-axis. |
Y title bold | N | Select this checkbox to make the title of the Y-axis bold. |
Y display opposite | N | Select this checkbox to make the Y-axis display opposite. |
Y Display grid | N | Select this checkbox to display the grid of the Y-axis. |
Y grid dotted | N | Select this checkbox to make the Y-axis grid dotted. Use this checkbox with the Y display grid field selected. |
Y from | N | Set the Y value used as the chart starting point. |
Y to | N | Set the Y value used as the chart endpoint. |
Y label size | N | Define the number of pixels to set the size of the Y label. |
List
List reports represent table data in the form of a list view.
Setting parameters
- Configure
- Title Style
Field | Mandatory | Description |
---|---|---|
List view | Y | Select a list view for a report with one of the list layouts configured. |
Items limit | Y | Define a limit of the table items used as a source for the report. |
Display all items | N | Select this checkbox to display all table items used for report configuration. When the checkbox is selected, the Items limit field is hidden. |
Field | Mandatory | Description |
---|---|---|
Report title show type | N | Select the type for the report title showing. Available options:
|
Report title | N | Specify the title of the report. |
Report title size | N | Specify the number of pixels to set the size of the report title. |
Report title color | N | Select the color of the report title. Click the magnifier icon to select one of the available colors. |
Title alignment | N | Set the alignment of the report title. Available options:
|
Bold title | N | Select this checkbox to make the report title bold. |
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
- Configure
- General Style
- Title Style
Field | Mandatory | Description |
---|---|---|
Column | Y | Set the desired table column as a column for the pivot table report. |
Row | Y | Set the desired table column as a row for the pivot table report. |
Aggregation type | N | Select the data aggregation to create combined datasets for data processing. Available options:
When this aggregation option is selected, it is applied to the table column set in the Aggregation column field. |
Aggregation column | Y | Select 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 limit | N | Set 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 other | N | Select 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. |
Field | Mandatory | Description |
---|---|---|
Drilldown list layout | N | Use this option to configure the view of the data slice drilled down. Click the magnifier icon to select the desired list view of the source table. See Personal list layout if you want to configure the list view. |
Decimal precision | N | Define how many numbers should be displayed after the point of numeric data values in your chart. This field appears when the Aggregation type field on the Configure tab contains Sum or Average. |
Field | Mandatory | Description |
---|---|---|
Report title show type | N | Select the type for the report title showing. Available options:
|
Report title | N | Specify the title of the report. |
Report title size | N | Specify the number of pixels to set the size of the report title. |
Report title color | N | Select the color of the report title. Click the magnifier icon to select one of the available colors. |
Title alignment | N | Set the alignment of the report title. Available options:
|
Bold title | N | Select this checkbox to make the report title bold. |
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
- Configure
- General Style
- Title Style
- Legend Style
Field | Mandatory | Description |
---|---|---|
Column | Y | Set the desired table column as a column for the heatmap report. |
Row | Y | Set the desired table column as a row for the heatmap report. |
Aggregation type | N | Select the data aggregation to create combined datasets for data processing. Available options:
When this aggregation option is selected, it is applied to the table column set in the Aggregation column field. |
Aggregation column | Y | Select 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 limit | N | Set 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 other | N | Select 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. |
Field | Mandatory | Description |
---|---|---|
High score color | N | Select the color used for high score values of the heatmap chart. Click the magnifier icon to select one of the available colors. |
Low score color | N | Select the color used for low score values of the heatmap chart. Click the magnifier icon to select one of the available colors. |
Drilldown list layout | N | Use this option to configure the view of the data slice drilled down. Click the magnifier icon to select the desired list view of the source table. See Personal list layout if you want to configure the list view. |
Decimal precision | N | Define how many numbers should be displayed after the point of numeric data values in your chart. This field appears when the Aggregation type field on the Configure tab contains Sum or Average. |
Field | Mandatory | Description |
---|---|---|
Report title show type | N | Select the type for the report title showing. Available options:
|
Report title | N | Specify the title of the report. |
Report title size | N | Specify the number of pixels to set the size of the report title. |
Report title color | N | Select the color of the report title. Click the magnifier icon to select one of the available colors. |
Title alignment | N | Set the alignment of the report title. Available options:
|
Bold title | N | Select this checkbox to make the report title bold. |
Field | Mandatory | Description |
---|---|---|
Show legend | N | Select this checkbox to display the chart legend. |
Legend alignment | N | Set the alignment of the chart legend. Available options:
|
Show ledgend border | N | Select this checkbox to display the border of your chart legend. |
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
- Configure
- General Style
- Title Style
Field | Mandatory | Description |
---|---|---|
Columns | Y | Define desired table columns as a data source for the multilevel pivot table report columns. |
Rows | Y | Define desired table columns as a data source for the multilevel pivot table report rows. |
Aggregation type | N | Select the data aggregation to create combined datasets for data processing. Available options:
When this aggregation option is selected, it is applied to the table column set in the Aggregation column field. |
Aggregation column | Y | Select 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 limit | N | Set 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 other | N | Select 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. |
Field | Mandatory | Description |
---|---|---|
Drilldown list layout | N | Use this option to configure the view of the data slice drilled down. Click the magnifier icon to select the desired list view of the source table. See Personal list layout if you want to configure the list view. |
Decimal precision | N | Define how many numbers should be displayed after the point of numeric data values in your chart. This field appears when the Aggregation type field on the Configure tab contains Sum or Average. |
Field | Mandatory | Description |
---|---|---|
Report title show type | N | Select the type for the report title showing. Available options:
|
Report title | N | Specify the title of the report. |
Report title size | N | Specify the number of pixels to set the size of the report title. |
Report title color | N | Select the color of the report title. Click the magnifier icon to select one of the available colors. |
Title alignment | N | Set the alignment of the report title. Available options:
|
Bold title | N | Select this checkbox to make the report title bold. |