View Source

Bar Report

Bar Reports display categorized data in 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.

SimpleOne Documentation (Official) > Report Types > Bar reports designer example.png

Configure tab

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 from one of the options:

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 was specified.

Add Data Table

N

Set 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:

Average – counts an average number of the column values.
Count – counts a number of entries.
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.

The aggregation option selected 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 is only available if the Aggregation Type option is 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 is only available if the Groups Limit option is specified.

Style tab

General

Field

Mandatory

Description

Chart Color Type

N

Select the color type of your bar chart from one of these options:

Use one color
Use color palette
Default.

Color

N

Set the color for your bar chart if you selected Use one color as the color type. Click on 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 on 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 on the magnifier icon to select a 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 in the Configure tab contains Sum or Average.

Title

Field

Mandatory

Description

Report Title Show Type

N

Select the type for the report title showing. Available options:

Never
Report Only
Always.

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 on the magnifier icon to select one of the available colors.

Title Alignment

N

Set the alignment of the report title. Available options:

Left Top
Left Bottom
Center Top
Center Bottom
Right Top
Right Bottom.

Bold Title

N

Select this checkbox to make the report title bold.

X

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 selected.

X Label Size

N

Define the number of pixels to set the size of the X label.

Y

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 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 Report

Pie Reports display data in a circular graphic divided into slices. Each slice proportionally displays a particular data category.

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

SimpleOne Documentation (Official) > Report Types > Pie reports designer example.png

Configure tab

Field

Mandatory

Description

Group by

Y

Select table columns as criteria for data grouping.

Add Data Table

N

Set this checkbox on to show the data table below your report view.

Aggregation Type

N

Select the data aggregation to create combined datasets for data processing. Available options:

Average – counts an average number of the column values.
Count – counts a number of entries.
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.

The aggregation option selected is applied to the table column set in the Aggregation Column field.

Aggregation Column

N

Select a table column with numeric values for data aggregation.

The Aggregation Column is only available if the Aggregation Type option is one of the following: Average, Count Distinct, Sum.

Groups Limit

N

Set the limit of the data groups shown in your report.

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 is only available if the Groups Limit option is specified.

Style tab

General

Field

Mandatory

Description

Chart Color Type

N

Select the color type of your pie chart from one of these options:

Use one color
Use color palette
Default.

Color

N

Set the color for your pie chart if you selected Use one color as the color type. Click on 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 on the magnifier icon to select one of the available palettes.

Display Data Lables

N

Select this checkbox to display the 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 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 in the Configure tab contains Sum or Average.

Title

Field

Mandatory

Description

Report Title Show Type

N

Select the type for the report title showing. Available options:

Never
Report Only
Always.

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 on the magnifier icon to select one of the available colors.

Title Alignment

N

Select the alignment of the report title. Available options:

Left Top
Left Bottom
Right Top
Right Bottom
Center Top
Center Bottom.

Bold Title

N

Select this checkbox to make the report title bold.

Legend

Field

Mandatory

Description

Show Legend

N

Select this checkbox to make the chart legend show.

Legend Alignment

N

Set the alignment of the chart legend. Available options:

Left Top
Left Bottom
Right Top
Right Bottom
Center Top
Center Bottom.

Show Legend Border

N

Select this checkbox to display the border of your chart legend show.

Gauge Report

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 set.

SimpleOne Documentation (Official) > Report Types > Gauge report designer example.png

Configure tab

Field

Mandatory

Description

Aggregation Type

N

Select the data aggregation to create combined datasets for data processing. Available options:

Average – counts an average number of the column values.
Count – counts a number of entries.
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.

The aggregation option selected is applied to the table column set in the Aggregation Column field.

Aggregation Column

N

Select a table column with numeric values for data aggregation.

The Aggregation Column is only available if the Aggregation Type option is 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.

Style tab

General

Field

Mandatory

Description

Chart Color

N

Select the color type of your pie chart from one of these options:

Use one color
Use several colors.

Color

N

Set the color for your gauge report if you selected Use one color as the color type. Click on 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 on 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 as you like.

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 in the Configure tab contains Sum or Average.

Title

Field

Mandatory

Description

Report Title Show Type

N

Select the type for the report title showing. Available options:

Never
Report Only
Always.

Report Title

N

Specify the title of the report you create.

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 on the magnifier icon to select one of the available colors.

Title Alignment

N

Select the alignment of the report title. Available options:

Left Top
Left Bottom
Right Top
Right Bottom
Center Top
Center Bottom.

Bold Title

N

Select this checkbox to make the chart title bold.

Digit Report

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

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

SimpleOne Documentation (Official) > Report Types > Digits report designer example.png

Configure tab

Field

Mandatory

Description

Aggregation Type

N

Select the data aggregation to create combined datasets for data processing. Available options:

Average – counts an average number of the column values.
Count – counts a 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.

The aggregation option selected 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 is only available if the Aggregation Type option is one of the followimg: Average, Count Distinct, Sum.

Style tab

General

Field

Mandatory

Description

Drilldown List Layout

N

Use this option to configure the view of the data slice drilled down. Click on 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 as you like.

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 in the Configure tab contains Sum or Average.

Color

N

Set the color for your digit chart. Click on the magnifier icon to select one of the available colors.

Title

Field

Mandatory

Description

Report Title Show Type

N

Select the type for the report title showing. Available options:

Never
Report Only
Always.

Report Title

N

Specify the title of the report you create.

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 on the magnifier icon to select one of the available colors.

Title Alignment

N

Select the alignment of the chart title selecting one of these options:

Left Top
Left Bottom
Right Top
Right Bottom
Center Top
Center Bottom.

Bold Title

N

Select this checkbox to make the chart title bold.

Line Report

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, etc.).

SimpleOne Documentation (Official) > Report Types > Leni report designer example.png

Configure tab

Field

Mandatory

Description

Trend by

Y

Select the table column of the Date/Time type to use it as a timeline period.

Group by

N

Select table columns as criteria for data grouping.

Per

N

Select a period as a grouping criterion. Available options:

Year
Quarter
Month
Week
Day
Hour
Date.

Combine Periods

N

Select this checkbox to combine data changes over the same period with each other.

Add Data Table

N

Select this checkbox to show the data table below your report view.

Aggregation Type

N

Select the data aggregation to create combined datasets for data processing. Available options:

Average – counts an average number of the column values.
Count – counts a 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.

The aggregation option selected is applied to the table column set in the Aggregation Column field.

Aggregation Column

N

Select a table column with numeric values for data aggregation.

The Aggregation Column is only available if the Aggregation Type option is one of the follwoing: 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 is only available if the Groups Limit option is specified.

Style tab

General

Field

Mandatory

Description

Chart Color Type

N

Select the color type of your line chart from one of these options:

Use one color
Use color palette
Default.

Color

N

Set the color for your line chart if you selected Use one color as the color type. Click on 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 on the magnifier icon to select one of the available palettes.

Display Data Labels

N

Select this checkbox to display the data labels on your line chart.

Drilldown List Layout

N

Use this option to configure the view of the data slice drilled down. Click on 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 as you like.

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 in the Configure tab contains Sum or Average.

Title

Field

Mandatory

Description

Report Title Show Type

N

Select the type for the report title showing. Available options:

Never
Report Only
Always.

Report Title

N

Specify the title of the report you create.

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 on the magnifier icon to select one of the available colors.

Title Alignment

N

Select the alignment of the report title. Available options:

Left Top
Left Bottom
Right Top
Right Bottom
Center Top
Center Bottom.

Bold Title

N

Select this checkbox to make the report title bold.

X

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 selected.

X Label Size

N

Specify the number of pixels to set the size of the X label.

Y

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 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.

Legend

Field

Mandatory

Description

Show Legend

N

Select this checkbox to make the chart legend show.

Legend Alignment

N

Set the alignment of the chart legend. Available options:

Left Top
Left Bottom
Right Top
Right Bottom
Center Top
Center Bottom.

Show Legend Border

N

Select this checkbox to display the border of your chart legend show.

Trend Report

Trend reports show the dynamics of data changes. The data is presented in columns over periods.

This report type is useful for monitoring time parameters.

SimpleOne Documentation (Official) > Report Types > Trend report designer example.png

Confugure tab

Field

Mandatory

Description

Trend by

Y

Select a column of the Date/Time type to use it as a time parameter you want to monitor.

Group by

N

Select table columns as criteria for data grouping.

Per

N

Select a time period for the data changed:

Year
Quarter
Month
Week
Day
Hour
Date.

Combine Periods

N

Select this checkbox to combine data changes over the same period with each other.

Add Data Table

N

Select this checkbox to show the data table below your report view.

Aggregation Type

N

The data aggregation allows preparing the combined datasets for data processing according to the user needs.

Select a type of the data aggregation with one of these options:

Average – counts an average number of the column values.
Count – counts a number of entries.
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.

The aggregation option selected 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 is only available if the Aggregation Type option is 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 is only available if the Groups Limit option is specified.

Style tab

General Style

Field

Mandatory

Description

Chart Color Type

N

Select the color type of your trend chart from one of these options:

Use one color
Use color palette
Default.

Color

N

Set the color for your trend chart if you selected Use one color as the color type. Click on 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 on the magnifier icon to select one of the available colors.

Display Data Labels

N

Select this checkbox to display the data labels on your trend chart.

Drilldown List Layout

N

Use this option to configure the view of the data slice drilled down. Click on 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 as you like.

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 in the Configure tab contains Sum or Average.

Title Style

Field

Mandatory

Description

Report Title Show Type

N

Select the type for the report title showing. Available options:

Never
Report Only
Always.

Report Title

N

Specify the title of the report you create.

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

Select the alignment of the report title. Available options:

Left Top
Left Bottom
Right Top
Right Bottom
Center Top
Center Bottom.

Bold Title

N

Select this checkbox to make the report title bold.

X

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 selected.

X Label Size

N

Define the number of pixels to set the size of the X label.

Y

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 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 Report

List Reports represent table data in a list view.

SimpleOne Documentation (Official) > Report Types > List report designer example.png

Configure tab

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.

Style tab

Title
Field	Mandatory	Description
Report Title Show Type	N	Select the type for the report title showing. Available options: Never Report Only Always.
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 on the magnifier icon to select one of the available colors.
Title Alignment	N	Select the alignment of the report title. Available options: Left Top Left Bottom Right Top Right Bottom Center Top Center Bottom.
Bold Title	N	Select this checkbox to make the chart title bold.

Pivot Table Report

Pivot Reports present your data in a table view by aggregating, grouping, and analyzing using two metrics as a row and column for your chart.

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

SimpleOne Documentation (Official) > Report Types > image2019-11-27_10-21-22.png

Configure tab

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:

Average – counts an average number of the column values.
Count – counts a number of entries.
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.

The aggregation option selected is applied to the table column set in the Aggregation Column field.

Aggregation Column

N

Select a table column with numeric values for data aggregation.

The Aggregation Column is only available if the Aggregation Type option is one of the following: Average, Count Distinct, Sum.

Groups Limit

N

Define the limit of the data groups shown in your report.

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 is only available if the Groups Limit option is specified.

Style tab

General

Field

Mandatory

Description

Drilldown List Layout

N

Use this option to configure the view of the data slice drilled down. Click on 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 as you like.

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 in the Configure tab contains Sum or Average.

Title

Field

Mandatory

Description

Report Title Show Type

N

Select the type for the report title showing. Available options:

Never
Report Only
Always.

Report Title

N

Specify the title of the report you create.

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 on the magnifier icon to select one of the available colors.

Title Alignment

N

Select the alignment of the report title. Available options:

Left Top
Left Bottom
Right Top
Right Bottom
Center Top
Center Bottom.

Bold Title

N

Select this checkbox to make the chart title bold.

Heatmap Report

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

SimpleOne Documentation (Official) > Report Types > Heatmap report designer example.png

Configure tab

Field

Mandatory

Description

Column

Y

Specify a table column as a column for the heatmap report.

Row

Y

Specify a 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:

Average – counts an average number of the column values.
Count – counts a number of entries.
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.

The aggregation option selected 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 is only available if the Aggregation Type option is 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 is only available if the Groups Limit option is specified.

Style tab

General

Field

Mandatory

Description

High Score Color

N

Select the color used for high score values of the heatmap chart. Click on 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 on 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 on 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 as you like.

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 in the Configure tab contains Sum or Average.

Title

Field

Mandatory

Description

Report Title Show Type

N

Select the type for the report title showing. Available options:

Never
Report Only
Always.

Report Title

N

Specify the title of the report you create.

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 on the magnifier icon to select one of the available colors.

Title Alignment

N

Set the alignment of the chart title selecting one of these options:

Left Top
Left Bottom
Right Top
Right Bottom
Center Top
Center Bottom.

Bold Title

N

Select this checkbox to make the chart title bold.

Legend

Field

Mandatory

Description

Show Legend

N

Select this checkbox to make the chart legend show.

Legend Alignment

N

Set the alignment of the chart legend, selecting one of these options:

Left Top
Left Bottom
Right Top
Right Bottom
Center Top
Center Bottom.

Show Legend Border

N

Select this checkbox to make the border of your chart legend show.

Multilevel Pivot Table Report

Pivot Tables Reports represent your data in a table view. The data is aggregated, grouped, and analyzed basing on two metrics (as a row and column).

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

SimpleOne Documentation (Official) > Report Types > Multilevel pivot report designer example.png

Configure tab

Field

Mandatory

Description

Column IDs

Y

Define desired table columns as data source for the Multilevel Pivot table report columns.

Rows IDs

Y

Define desired table columns as 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:

Average – counts an average number of the column values.
Count – counts a number of entries.
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.

The aggregation option selected is applied to the table column set in the Aggregation Column field.

Aggregation Column

N

Select a table column with numeric values for data aggregation.

The Aggregation Column is only available if the Aggregation Type option is one of the following: Average, Count Distinct, Sum.

Groups Limit

N

Define 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 is only available if the Groups Limit option is specified.

Style tab

General

Field

Mandatory

Description

Drilldown list layout

N

Use this option to configure the view of the data slice drilled down. Click on 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 as you like.

Decimal Precision

N

Set the number defining how much numbers should be displayed after the point of numeric data values in your chart.

This field appears when the Aggregation Type field in the Configure tab contains Sum or Average.

Title

Field

Mandatory

Description

Report Title Show Type

N

Set the type for the report title showing. Available options:

Never
Report Only
Always.

Report Title

N

Specify the title of the report you create.

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 on the magnifier icon and, in the window appeared, select one of the available colors.

Title Alignment

N

Select the alignment of the report title. Available options:

Left Top
Left Bottom
Right Top
Right Bottom
Center Top
Center Bottom.

Bold Title

N

Select this checkbox to make the chart title bold.