Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Merged branch "DOC0001039" into parent

SimpleOne allows creating reports using the Report Designer and directly from the data table.

Note

The Report Designer can stop the report generating if the data amount is too large to display. Use the Condition Builder to limit the data sampling or try another type of report.

Create report from list layout

description

Create from the Tables


You can create a chart out of any column, just clicking on its title. The reports generated in this way use ta report via list layout directly from the list view using a table column as the grouping criteria.

Info

Pie and bar Bar charts are only available for this type way of report creating.


To create a report from a table, follow the steps below:

  1. Navigate to the source table you need.
  2. Chose a Click on the table column as , which will be a data grouping criteria and right-click on it.
  3. Select one of the context options:
    • Pie chart - to Chart – to generate a pie report.
    • Bar chart - Chart – to generate a bar chartreport.
    • Export Excel - to export an excel document with datatable.
      Image Removed
  4. You will see your chart in the Report Designer view.
    Image Removed

    • Image Added

  5. In the Report Designer, customize Customize your report data and style with the Report Designer tools in a way you need.in the tabs.
  6. Click Refresh to see the changes.

    Image Added

  7. Click Save to apply changes.


Create reports with

the

Report Designer

Go
  1. Navigate to the Reports → Create
a Report menu, and follow the steps below: InfoClick Next or the tabs of the Report Designer to navigate. This navigation is only available after filling in the mandatory fields
  1. New menu.
    1. Set the

    Data
    1. data.

    2. Select the
    Type
    1. type.
    2. Configure the
    report options
    1. data.
    2. Customize the
    Style.
Set the Data
    1. style.
  1. Click Save to apply changes.
Info

To navigate through the Report Designer, use the Back and Next buttons or click on the tabs after filling in the mandatory fields.


Anchor
Specify report data
Specify report data
Specify report data

Panel
titleFollow the steps below to set the data:
  1. On the Data tab, fill in the mandatory fields: 
    1. Report name - Name – enter the desired name;.
    2. Table - select – select the table you need.
  2. Click Next or the Type tab.

Image Removed

Select the Type

Image Added

Anchor
select the type
select the type
Specify report type

Panel
titleFollow the steps below to set the report type:
  1. On In the Type tab, select a type of your report.
  2. Click Next or the Configure tab.

Image Removed

Configure the report

Image Added


Note

Note that changing existing report type is not allowed. You can create new record with similar data but of another type instead. For this, please complete the steps below:

  1. Open the report you need to clone.
  2. In the hamburger menu on the report form, click Duplicate.
  3. Specify necessary data, including new type, for the newly created report.
  4. Click Save to save this report.


Anchor
Configure report data
Configure report data
Configure report data

Panel
titleFollow the steps below to configure the report:
  1. On

    In the Configure tab, fill in the

    set option

    fields determined by the report type selected. The reports of the Bars, Pies, Time Series, and Multidimensional category types have mandatory fields.

    Info
    • Use the Condition Builder to establish additional conditions for your report data filtering and grouping. Click the funnel icon Image Added to open it.
    • Reports do not support the use of the Journal Input fields (the Additinal comments and Work notes fields).


  2. (Optional) Activate the Add Data Table checkbox to add data in table format to your report.

    Info

    This option is available for reports of the following types: Bar, Pie, Line, Trends.

    Image Added

  3. (Optional) Set the Aggregation Type and select the Aggregation Column of the source data. The data aggregation allows preparing the combined datasets for data processing according to the user needs.

    Available Aggregation Type 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.


      Info

      The Sum and Average settings make sense if the aggregation column keeps the numeric data.


    Info

    This option is available for reports of the following types: Bar, Pie, Gauge, Digits, LineTrendsPivot Ttable, HeatmapMultilevel Pivot Table.


    Image Added

  4. (Optional) Limit the number of data categories displayed with the Groups Limit option. It limits the number of categories specified in the Group by field. Enter the number you want and set the Show Rest as Other checkbox active, if you want to show the categories not included in the limit as the last group.

    Info

    This option is available for reports of the following types: Bar, Pie, Line, Trends, Pivot Table, Multilevel Pivot Table, Heatmap.

    Image Added

  5. Click Refresh to generate a report.
  6. To customize the report style, click

    Click Next or the Style tab to customize the report style.

  7. To Click Save to save the report, click Save.
Image Removed
  1. .



Anchor
Customize report style
Customize report style
Customize

the

report

Style

style

Panel
  1. On

    In the Style tab, configure the style options. 

    Info

    Each report type defines its own style settings.

  2. Click Refresh to apply the changes.
  3. Click Save to save the report.
Info
Use the Condition Builder to establish additional conditions for your report data filtering and grouping.
Image Removed

Data Drilldown

dc

Image Removed

nggn

Image Removed

Report Types

Depending on the report Type selected, the set of configuration fields changes. To learn more, follow the links below.

Bar Reports

Column
width20%
Image Removed
Column

    • (Optional) In the General panel, use the Drilldown List Layout option to configure the view of the data slice drilled down. Click the magnifier icon Image Added and, in the window appeared, select the desired list view of the source table.

      Info

      See Personal list layout if you want to configure the list view.

      Image Added

  1. Click Refresh to apply the changes.
  2. Click Save to save the report.

Image Added


Report types

Create a Bar Report

Bar Reports display categorized data in vertical bars which length is proportional to the data values. Stack or group bars to make the chart representation visual and clear.

Bar Reports display data as vertical bars with lengths proportional to data values they represent.

This report view is useful for

deviding

dividing data into categories and comparing them.

 

Create

Bar Reports

a Pie Report

Pie Reports

Column
width20%
Image Removed
ColumnPie reports

display data in a circular graphic divided into slices. The whole graph represents the entire report data

along

with each slice proportionally displaying a particular data category

Create Pie Reports

Gauge Reports

Column
width20%
Image Removed
Column

.

This report view is useful to compare the proportions of individual values to the whole.

Create a Gauge Report

Gauge Reports represent a single metric value from the

table

data

by

via the gauge panel with

the arrow and

a dial on it.

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

Create

Gauge Reports

a Digit Report

Digit Reports

Column
width20%
Image Removed
ColumnMake simple reports with

provide a simple digit representation of a single metric value.

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

Create

Digits Reports

a Line

Reports
Column
width20%
Image Removed
Column

Report

Line Reports represent data as

line

a graph of points connected by

segments

a line and

visualizing

visualize the metric data values. 

This report view is useful for comparing data per time periods (years, months, etc.).

Create

Line Reports

Pivot Tables

Column
width20%
Image Removed
column

a Pivot Table Report

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

This report

type

view is

extremely useful

 useful for issues of

comparasing

comparing, summarizing, and counting a large amount of data.

Create a Multilevel Pivot

Reports

Table Report

Trend Reports

Column
width20%
Image Removed
Column
Trend Reports display data as columns over time.
Create Trends Reports
Heatmap Reports
Column
width20%
Image Removed

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

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

Create a List Report

List Reports represent table data in a list view.

Create a Heatmap Report

column

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.

Create

Heatmap Reports

Multilevel Pivot Reports

Column
width20
Image Removed
Column

a Trend Report

Trend reports show the dynamics of data changesThe data is represented as columns over periods.

Pivot Reports represent your data in a table view with aggregating, grouping and analyzing using more than two metrics as columns and cells for your chart.

This report type is

extremely useful for issues of comparasing, summarizing, and counting a large amount of data.

Create Multilevel Pivot Reports

List Reports

Column
width20%
Image Removed
ColumnList Reports display data in a list

useful for monitoring time parameters.


Table of Contents
maxLevel32
classfixedPosition