Analyses and reports
The raw data says little about the production efficiency of the plant. Only a careful analysis thereof will provide information that will become the basis for activities that take factory management to a higher level.
The IPLAS system offers a wide range of data visualization options, such as charts, tables or synoptic maps. It will allow to build a customized reporting dashboard.
Time is of the essence when it comes to preventing waste. That is why it is so important to rely on current information. Automatic reports update will help you make the best decisions – in the vast majority of cases, they refresh even every few seconds! Information on how to create them can be found hereinbelow.
Example of creating analyses and reports
The video below shows the process of creating an analysis that uses the existing processing, and then how to attach the analysis to a report.
The selected type of analysis is the Gannt chart, which is a graphical overview of the course of the operation, taking into account its downtime.
A few words of explanation for the video above:
- Stages of creating analysis
- Steps for adding an analysis to a report
- Creating a new analysis (in this case it is a Gannt chart)
- Selecting a data range
- Defining the destination from which data is retrieved
- Defining a text variable, a variable containing information about the start/end time of intervals, a variable containing information about the number of pulses in a given interval.
- Retrieving types defined in processing
- Chart preview
- Saving analysis
- Creating a new report
- Using a previously created analysis
- Saving a report
Documentation
Chart
 | ChartVisualization that allows to present data using a chart. |
DESCRIPTION:
The chart is a graphical analysis with which the user can visualize the data series defined by him/her..
CONFIGURATION:
In order to configure the chart correctly, in the first step should be to give it a name and specify the data refresh frequency.
When creating a graph analysis, what will be displayed on the x-axis should be specified by selecting time or a variable. When defining the time, the period from which the data will come should be marked. The chart can present all collected data or those selected from a specific period (quarter, hour, day, week, month).
When defining a variable as the x-axis, the number of presented lines on the chart should be chosen.
The next step is to select the target that will be used in the analysis. When selecting time as a variable on the X axis, it is possible to select several different targets.
Switching to the Series tab allows to add and configure the data series that will be displayed. To add a new data series, the Add new data series button must be clicked. This will display a row for the new series that needs to be set up in the next steps.
In order to properly configure a series of data, first, the target should be indicated, and then the column from which the data will come. The next step is to give a series name and select its type. The system enables displaying data series in the form of a bar, straight or smooth line chart. The user can also specify the data series colour, line thickness, style, and fill. Marking the checkboxes next to the values and points enables their visibility on the chart of a given series.
When creating an analysis with a selected variable on the X axis, the configuration of the data series should be started by indicating in the Displayed field on the x axis, the variable that will be displayed on the horizontal axis. Adding a new data series is done in a similar way to the previously described case, with the difference that in the Aggregation field, select the type of data aggregation by which the data will be grouped by quantity, number of unique records, sum, average, maximum or minimum.
The user also has the option to edit the chart axis and define his/her own Y axis. The Edit chart axes button opens the axis editing window, in which we can name the X and Y axes, set their visibility on the presented chart and, thanks to the equal spacing option, define the location of data on the axis.
For the X axis, also the minimum period of data presentation can be specified, starting from milliseconds through seconds, minutes, hours, days, weeks, months and years. If time has been selected as the variable on the X axis, it is possible to select its format.
By editing the Y axis, the user can determine the minimum and maximum of the scale presented on the axis and its position on the right or left side of the chart.
21. Each configured data series can be edited and removed from the view on the chart by clicking the trash can button in the Actions column. Using the arrows button in the same column, one can freely arrange their order on the chart. The Generate graph button allows to display the configured analysis on the screen.
A correctly configured analysis should be saved using the Save analysis button..
OPTIONS:
| Name | Description |
|---|---|
| Name* | Name of analysis |
| Description | A field that contains information about the analysis |
| Refresh time [s] | Value in seconds, specifying how often to refresh the data in the analysis |
| Chart title | Any name/title of the configured chart can be entered |
| Chart title visibility | Displaying the entered title above the graph |
| X axis type | |
| Time | Option to use time as the period from which the data is to come |
| Choosing a period | Selection of the period from which the data will be taken into account (quarter, hour, day, week, month, all data) |
| Variable | Option to use setting the selected variable on the X axis |
| A variable as the X axis was selected. Enter the number of rows | The number of rows displayed in the chart |
| Target | |
| Select the target to be used in the chart | A field in which a choice is made from which destination the data will originate |
| Series | |
| Shown on the X axis* | Selecting the variable from which the data will be derived that will be placed on the X axis |
| Legend | Explanatory text attached to the chart containing information about the series occurring |
| 3D | Ability to show the graph in three-dimensions |
| Target | Selecting the destination from which the data will originate |
| Column | Selection of the variable whose values will be presented on the chart |
| Name | The name of the column shown in the chart |
| Aggregation | Selecting the type of data series grouping |
| Series type | Selection of the type in which the data series are to be presented on the chart (bar, straight line, smoothed line) |
| Colour | Possibility to choose the colour of a given data series |
| Values | Displays the values on a chart grid |
| Points | Displays the values on a chart grid |
| Filling | Fills a data series with a defined colour |
| Thickness | Possibility to choose the thickness of the lines presenting the data series |
| Style | Possibility to define the style of lines presenting data series (continuous, dotted, dashed, strongly dashed) |
| Y axis | Giving a name to the Y axis relative to which the data series will be presented |
| Actions | A place where a given series of data can be deleted and their order arranged on the chart |
| Add new serie | Option to add another row to configure new data series to be displayed on the chart |
| Next, Back button | It allows to switch between Bookmarks |
| Generate Chart button | It allows to visualize the configured graph |
| Save analysis button | Saves the configured analysis |
| Edit the axes of chart | Opens the Edit chart axis window |
| Chart axis edition window | |
| X axis | |
| Name | X axis name |
| Visible name | Displaying the entered name of the X axis on the chart |
| Minimum period | Selection of the period for which the data will be displayed |
| Equal Spacing | Allowing the data presentation to be arranged at equal intervals on the chart |
| Y axes | |
| Name | Y axis name |
| Name visibility | Displaying the entered name of the Y axis on the chart |
| Stacked | It allows to display different series of data on one bar |
| Minimum, Maximum | Specifying the range of the scale that is shown on the Y axis |
| Position | Set the visibility of the Y axis to the right or left of the chart |
| Actions | A field with a Trash button that can be used to delete the given Y axis |
| New y axis button | Adding another axis |
| Save, Cancel button | Save or cancel editing of the chart axis |
*- required fields
Table
 | TableAnalysis presenting data set |
DESCRIPTION:
Table analysis is a way of presenting a series of data in well-spaced columns and rows that allows to organize and analyse related data.
CONFIGURATION:
In order to properly configure the analysis in the form of a table, in the first step a name should be given and the data refresh frequency should be specified. The next step is to choose the target from which the data will originate.
A table with data is created by dragging a variable from the list of columns and dropping it on a blue background. In the Rows count field you can define their number in the table. Variable data can also be sorted depending on their types (descending, ascending, alphabetically). The analysis also allows to filter the data by entering the search phrase in the text field of the analysed column. The Clear filters button resets filtering.
A correctly configured analysis should be saved using the Save analysis button.
OPTIONS:
| Name | Description |
|---|---|
| Name* | Name of analysis |
| Description | A field that contains information about the analysis |
| Refresh time [s] | Value in seconds, specifying how often to refresh the data in the analysis |
| Choose the target | A field in which a choice is made from which destination the data will originate |
| Columns | Defined variables with data in the destination where the table is to be transferred |
| Rows count | Ability to define the number of rows of visible rows in the table |
| Sort arrows | It allows to sort data in ascending, descending and alphabetical order |
| Filtering place | It allows to filter data by entering a search phrase in the text field of the analysed column |
| Refresh button | Refreshes the visibility of the specified number of rows in the table |
| Clear Filters button | Reset filtering |
| Save analysis button | Saves a correctly configured analysis |
Pie chart
 | Pie chartPie chart divided into slices showing proportions |
DESCRIPTION:
A pie chart is a chart that, when broken into slices, simply illustrates the percentage of values that are contained within one data set.
CONFIGURATION:
In order to configure the analysis correctly, in the first step should be to give it a name and specify the data refresh frequency. Next, the chart title should be entered and the option ‘visible chart title’ selected, if the entered title is to be displayed on the chart.
When creating a graph analysis, the data range must be specified. The Time option allows to select the period from which the data will come. The chart can present all collected data or those selected from a specific period (quarter, hour, day, week, month). The Number of rows option allows to use the number of rows as the period from which the data is to be considered.
The next step is to select the target that will be used in the analysis.
Switching to the Series tab allows to configure the data series that will be displayed on the diagram. First, the Series Column should be selected from the previously selected destination, on the basis of which the chart will be divided into parts, and then the Value Column containing the values for each series should be selected. In the Aggregation field, the type of data aggregation by which the data will be grouped by quantity, number of unique records, sum, average, maximum or minimum should be specified. Selecting Values allows to display the data label in the chart, and the Legend option displays the labels of the series variable in the legend.
The Generate chart button allows to display the configured analysis on the screen.
A correctly configured analysis should be saved using the Save analysis button.
OPTIONS:
| Name | Description |
|---|---|
| Name* | Name of analysis |
| Description | A field that contains information about the analysis |
| Refresh time [s] | Value in seconds, specifying how often to refresh the data in the analysis |
| Chart title | Any name/title of the configured chart can be entered |
| Visible chart title | Displaying the entered title above the graph |
| Scope of data | |
| Time | Option to use time as the period from which the data is to be taken into consideration |
| Choosing a period | Selection of the period from which the data will be taken into account (quarter, hour, day, week, month, all data) |
| Number of rows | Option to use the number of rows as the period from which the data is to be taken into account |
| Enter number of rows | The number of rows displayed in the chart |
| Target | |
| Choose target which will be used in the chart | A list in which a choice is made from which destination the data will originate |
| Series | |
| Series column | A column based on the value of which the graph will be divided into parts |
| Values column | A column containing values for each series |
| Aggregation | Type of value representation in each series (quantity, unique number, sum, average, minimum, maximum) |
| Values | Values of individual series after their aggregation |
| Legend | Explanatory text attached to the chart containing information about the series occurring |
* Required field
Table of current data
 | Table of current data |
DESCRIPTION:
The Table of current data is an analysis which allows the user to conditionally style variables and change the format of the displayed data. The data presented can come from different destinations.
CONFIGURATION:
In order to properly configure the analysis in the form of a table of current data, in the first step a name should be given and the data refresh frequency should be specified.
By clicking the New row button, consecutive rows of the table are created, in which the name of the displayed value is given, the destination from which the variables will come is chosen and the column with the data is selected.
The Configuration button opens the Style Window, which allows to define the conditions, format and visualization of the presented data. Within the analysed row of the table, several conditions can be defined by specifying their type and value for one or more variables, as well as the display styles of the presented data can be selected.
The Data format tab allows the user to define the number of decimal places and the unit in which numerical variables are to be presented. For variables containing data in the form of date and time, it allows to define the format displayed in the text table. In turn, for variables containing text, the unit in which the data is to be presented must be selected.
The introduced modifications can be previewed by clicking the Preview button.
A correctly configured analysis should be saved using the Save analysis button.
OPTIONS:
| Name | Description |
|---|---|
| Name* | Name of analysis |
| Description | A field that contains information about the analysis |
| Refresh time [s] | Value in seconds, specifying how often to refresh the data in the analysis |
| New row button | Adds consecutive rows to the table |
| Name | Name of the displayed value |
| Value | Selecting the destination from which the variables will originate |
| Selecting which variable/column from the previously selected destination the data will originate from | |
| Actions | The trash can button removes the row from the table |
| Arrow buttons with which we can freely arrange the order of the rows in the table | |
| The Configuration button opens the Style Window | |
| Styles window | |
| Conditional styles | The tab allows to assign conditions and styles to the data within the analysed row in the table |
| New row button | Adds a row that allows to define conditions and styles for the data within the row being analysed in the table |
| New condition button | It opens fields that allow to specify several types and values of conditions for selected variables within the analysed row in the table |
| New style button | Adds fields where the style of the data to be presented can be determined after specifying its conditions |
| Styles | A field where the following can be chosen: font size and style, text colour, background colour, symbol, text alignment |
| Font size | Selecting the font size in which the data will be presented after the condition is met |
| Font style | Option to choose the font style (normal, italic, bold, bold italics) in which the data will be presented after meeting the condition |
| Text colour, background colour | Possibility to set using the colour palette, the colour of the text or the background of the data when the condition is met |
| Symbol | Selection of the symbol with which the data will be presented. Symbol can be error, warning or information |
| Text alignment | The buttons can be used to justify the text to the left, right or in the middle of the table rows |
| Data format (variables containing numerical data) | The tab in which the data presentation format is determined by specifying the number of decimal places and the unit |
| Number of decimal places | Possibility to define the number of decimal places with which the data should be presented |
| Separator | Checking allows to separate the integer part from the fractional part in the record of the number presenting the data |
| Unit | Selection of the unit in which the data is to be presented |
| Data format (variables containing date and time data) | A tab where the format in which the text will be displayed is chosen |
| Data format (variables containing text data) | A tab in which the format in the form of the unit in which the data should be presented is chosen |
* Required field
Gauge
 | GaugeVisualization presenting the current state of the measured value |
DESCRIPTION:
The Gauge is an analysis by which the user can monitor the current value of a given column from the destination and present it with a scale with a pointer.
CONFIGURATION:
In order to configure the analysis correctly, in the first step should be to give it a name and specify the data refresh frequency. Then the target should be chosen and, in the Select column field, the column from which the data will originate should be selected.
In further steps, the user can adjust the meter to the presented data by configuring the scale, range and shape of the meter. The analysis configuration also allows to visualize the meter graphically by entering its title, specifying the displayed data unit and adding coloured intervals to improve the reading of data from the chart. The introduced configuration changes can be previewed by clicking the Preview button.
The introduced configuration changes can be previewed by clicking the Preview button.
A correctly configured analysis should be saved using the Save analysis button.
OPTIONS:
| Name | Description |
|---|---|
| Name* | Name of analysis |
| Description | A field that contains information about the analysis |
| Refresh time [s] | Value in seconds, specifying how often to refresh the data in the analysis |
| Select target | Selecting the destination from which the data will originate |
| Select column | Selection of the variable/column from the previously selected destination the data will come from (the destination must be selected first) |
| Enter a chart title | The name of the given chart displayed on the analysis |
| Enter a unit | Selection of the unit of the analysed data displayed on the gauge |
| Enter the minimum | Specification of the minimum scale range visible on the meter |
| Enter the maximum | Specification of the maximum scale range visible on the meter |
| Limiting values to min. and max. | Ensures that the gauge needle does not go beyond the minimum and maximum ranges |
| Graduation scale step | Defining how many units the numerals will be visible on the gauge scale |
| Shape | Selecting one of the available gauge shapes |
| The width of the intervals bar | Slider on which the percentage of interval visualization of intervals from the centre of the measure can be selected |
| The width of the inner bar of steps | Slider on which the percentage distance between the visualization of intervals from the outer edge of the meter can be selected |
| The upper values of the ranges New interval button | Button for adding another interval on the meter |
| The upper values of the ranges Editing interval | Interval edition allows to define the range ranges and their colour |
* Required field
Gantt chart
 | Gantt chartGraphic analysis showing the course of operation. |
DESCRIPTION:
The Gantt diagram is an analysis that allows the presentation of charts showing the schedule of the workflow of machines, their delays and downtimes along with their duration. The time is usually on the X axis, and the units we use can be freely configured. The Y axis is a list of operations in a given process. The ability to zoom in on the timeline view allows to analyse the details of a diagram that shows processes over a long period of time.
CONFIGURATION:
In order to configure the chart correctly, in the first step should be to give it a name and specify the data refresh frequency.
One can choose the scope of the data, i.e. the period from which the data will come. Then, in the Data source field, the destination on the basis of which we create the chart must be selected. The next step is to define a text variable storing the series names in the Column with series type field. In the column with the start/end time, a variable containing information about the start/end time of the intervals is chosen. It is required to select a variable that stores information about the number of pulses in a given interval.
Using the Download types button, we search for series previously defined in the processing, which are displayed in the table after clicking. These data can be freely edited – their name, colour the data series and set the visibility on the chart can be determined. The analysis also enables the deletion of data series and any ordering of their order on the chart.
The Preview button allows you to visualize the chart in advance before saving it.
A correctly configured analysis should be saved using the Save analysis button.
OPTIONS:
| Name | Description |
|---|---|
| Name* | Name of analysis |
| Description | A field that contains information about the analysis |
| Refresh time [s] | Value in seconds, specifying how often to refresh the data |
| Data scope | Selection from what point frames shall arrive |
| Data source | Choosing the destination from which to create the chart |
| Column with the series type | Selection of the text variable holding the series names |
| Column with the start time | Selection of a variable containing information about the start time of the intervals |
| Column with the end time | Selection of a variable containing information about the end time of the intervals |
| Column with the number of pulses | Selection of a variable containing information on the number of pulses in a given interval |
| Show only defined series | Denotes that only the series that have been defined in processing will be displayed |
| Border like serie color | It denotes that the border of the given interval will be the same as the given colour of the series |
| Download types | Adds data series defined in processing |
| Series definition table | |
| Code/Name | Name of the types of series |
| Colour | Possibility to choose the colour of a given data series |
| Visible in the chart | Displaying the entered name on the chart |
| Show if no data | A given series is visible on the chart even though no data frames for a given series are coming |
| Actions | A place where a given series of data can be deleted and their order arranged freely on the chart |
* Required field
Synoptic map
 | Synoptic mapVisualization enabling presentation of current data |
DESCRIPTION:
The synoptic map is a graphical analysis presenting current data for specific elements of the production process. Each user can choose the labels of interest according to his/her own needs.
CONFIGURATION:
In order to properly configure the synoptic map, one should first give it a name, define the data refresh rate and select the image that will be its background. The user can load any picture of his/her choice available on the device, and then save or cancel this selection.
When creating an analysis in the form of a synoptic map, it is necessary to define what variables will be displayed on it. For this purpose, the user generates a New element, giving it a name, selecting the processing with the column of interest and confirming with the Add element button. It is also possible to add an indicator whose value is defined by the user. Generating such a label takes place after selecting the “Constant” checkbox.
The created label is a movable element, the position of which can be freely changed by the user.
The user can edit or delete the indicators generated by him by clicking on the selected label.
A correctly configured analysis should be saved with the Save analysis button.
OPTIONS:
| Name | Description |
|---|---|
| Name* | Name of analysis |
| Description | A field that contains information about the analysis |
| Refresh time [s] | Value in seconds, specifying how often to refresh the data in the analysis |
| Select image | The background image for the analysis |
| New image | Option to add a new image for analysis |
| Select button | Option to select a file from the device |
| Save button | Save the selected file |
| Cancel button | Cancel image selection |
| New element button | Adding a new indicator displayed on the analysis |
| Indicator name | The name of the variable displayed in the analysis |
| Processing | Selecting one of the available processing from which the data will come |
| Variable/Column | Selection of the variable whose values will be presented on the chart |
| Constant | Selection of the variable whose values will be presented on the chart |
| Unit | Selection of the unit of the analysed data displayed on the synoptic map |
* Required field
REPORT
The report is a layer that allows to present the knowledge extracted from the data in a clear and understandable way. Reports are made up of analyses, e.g. tables, charts or measures.
As the presentation layer is based on already processed data, reports refresh almost immediately. Thanks to this, it is possible to create information screens containing reports refreshed every few seconds, e.g. information about the production progress of the current order, enriched with coefficient values such as OEE or MTBF.
CONFIGURATION:
In order to create a report correctly, one should first give it a name. In the next steps, the user can select the ones he wants to put on the report from the previously performed analyses. The report may consist of many elements of different types. Remove unused fields by clicking on the Trash icon.
The changes made should then be saved.
The content of the report will be automatically refreshed according to the time interval set for the analyses creating the report (e.g. every 15 seconds). This interval may be different for different analyses.
DIRECT LINK GENERATION
DESCRIPTION:
The direct link generation function allows easy access to reports and displaying them in full screen mode on any device with access to the network.
In addition, thanks to this function, the user has the option of sharing a specific report with selected people for a specified time. This allows unregistered persons to access a given report, regardless of their location.
CONFIGURATION:
In order to generate a direct link correctly, on the list of reports, the Generate link button must be selected from the possible Actions, located in the line with the name of a given report.
In the next steps, the user can set the link access expiry date, enable full screen mode and copy the link.
The changes made should then be saved for the generated link to work properly.
After saving the generated link, the Generate link button will be highlighted green, which means that the link is active. Orange colour means that the link is generated but inactive (the link’s expiry date has not yet been or has already expired), and the blue colour – no link has been generated.
