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
Visualization that allows to present data using a chart.
The chart is a graphical analysis with which the user can visualize the data series defined by him/her..
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..
|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|
|Select the target to be used in the chart||A field in which a choice is made from which destination the data will originate|
|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|
|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|
|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 of current data
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.
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
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.
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.