An Analysis is a visual display of data from the following data sources within Tulip
App: Data is organized around App Completions from the past
Table: Data is current values in Table Rows
Machine: Data is past events from OPC tags that are stored in attributes
It is defined via:
This doc will review all the possible configuration fields for each chart template and data source combination.
Additionaly, Chart Layers allowing to create Insights are detailed at the end of this page.
Name | Description |
---|---|
Name | Name of the Analysis |
Sharing | Refresh Seconds The frequency that the visual display will refresh with new data. Minimum 5 seconds.Public Link An optional public link that will allow anyone to view data in the analysisDownload Image Download the current state of the analysis in a PNG image |
Apps (Apps data source only) | A list of apps that act as a data source for this analysis |
Table (table data source only) | The table data source for the analysis |
Machine (machine data source only) | The machines under a specific machine type that will be considered in the analysis |
Date Range | Apps data The date range for values that will be considered in this chart based on when the app completion with the data point occurredMachine data The date range for values that will be considered in this chart. The user can select one of two system generated fields as a reference:
The date range for the "Start Time" of machine activity entries that will be considered. |
Filters | Any exclusion or inclusion rules for data in this chart. |
Compare By | A category to split out the data into multiple series. |
The formatting options are configured in the formatting panel on the right side of the analytics editor. They are grouped into give sections and are available for all templates but Single Number, Table and Slideshow.
Applies to all charts.
Name | Description |
---|---|
Show Legend | Legend is shown on the chart when toggled on. |
Applies only to charts with a X axis.
Name | Description |
---|---|
Label | Defines if and what axis label is shown. The options are:
|
Axis Scaling Only available when a datetime value is selected for the x axis | Defines what scale is used for the X axis. The options are:
|
Show X Axis Tick Labels | Defines if axis tick labels for the X axis are shown. |
Tick Label Rotation | Defines the degree rotation of tick labels. Available options are 0°(default), 45° and 90°. |
Applies only to charts with a Y axis.
Name | Description |
---|---|
Label | Defines if and what axis label is shown. The options are:
|
Show Y Axis Tick Labels | Defines if axis tick labels for the Y axis are shown. |
Bounds | Allows to set fixed bounds for the maximum and minimum of the Y axis. |
Applies only to line and multiline charts.
Name | Description |
---|---|
Interpolation | Allows to select if the line interpolation is smooth or straight. |
Applies only to the donut chart.
Name | Description |
---|---|
Show Labels | Defines if the data labels for the different donut segments are shown. |
This displays one variable or table field on the X axis and a numerical value on the Y axis.
Name | Description |
---|---|
X Axis | The data point whose values will determine the categorization of data on the graph |
Y Axis | The numerical data point that will be organized based on the X Axis values For datetime values: GROUP VALUE - Grouping of data by minute, hour, day, week, month, quarter or year. |
Display Options |
|
This displays multiple numerical or boolean variables or table fields on the X axis and a numerical value on the Y axis.
Name | Description |
---|---|
X Axis | The variables (App analysis), Table fields (Table analysis) or machine fields (machine analysis) that will be shown for comparison on the X axis of the chart |
Y Axis | The numerical value values for each selected variable or field. |
Display Options |
|
This displays multiple numerical or boolean variables or table fields on the Y axis across the same X axis. Available for
Name | Description |
---|---|
X Axis | The value for the common X Axis |
Y Axis | The values to be compared across the common X Axis |
Display Options |
|
This shows individual app completions on the X axis and a numerical or boolean value on the Y Axis. Available only for App analyses.
Name | Description |
---|---|
Y Axis | The list of numerical variables or table fields to compare for each individual app completion |
Display Options |
|
This shows one numerical table field or variable on the x axis and a numerical value on the Y axis. Available only for App analyses.
Name | Description |
---|---|
X Axis | The variable to be shown on the X Axis. |
Y Axis | The variable to be shown on the Y Axis. |
Sorting | Allows to select a field and direction for sorting. |
Limit | Limit the number of data points shown on the graph. |
This shows a single value based on a variable, field or expression.
Name | Description |
---|---|
Number | The variable, field or expression to be shown. |
This shows images of a single image variable and additional variable values next to it. Available only for App analyses.
Name | Description |
---|---|
Image | The image variable shown in the slideshow. |
Columns | Additional app data that should be shown alongside the image in the slideshow. |
This shows a tabular overview of the selected data.
Name | Description |
---|---|
Groupings | The variables (App analysis), Table fields (Table analysis) or machine fields (machine analysis) used for grouping the source data. This drives which rows are shown in the table. |
Columns | Additional columns whose aggregated value should be shown for each grouping. |
Sorting | Allows to select columns which the table should be sorted by. |
Limit | Limits the nubmer of data points shown on the graph. |
All analyses are limited to a maximum of 1000 visualized records. If the analysis configuration would return more than 1000 records, last 1000 records are shown. "Last" is defined by a descending order of the X Axis values.
Example: If the X Axis is configured to be a datetime field, the most recent 1000 records will be shown.
All analyses are limited to a maximum of 50 visualized series. If the analysis configuration would return more than 50 series, the first 50 are shown. If this is the case, a warning icon is shown on the chart to surface it to the user.
Layers can be added to certain chart types in Tulip to generate Insights. Insights are pieces of information that are extracted from or created using the data visualized in the analysis.
This layer can be added to Tulip Table analyses with the following configuration:
The Layer can be turned on in the "Chart Layers" side panel which can be accessed using the "Chart Layers" button in the top right corner of the analytics editor. It offers two different limit settings with different configuration options.
Allows to manually define an upper and lower control limit and a center line to use single outlier and prominent shift rules.
Option | Description |
---|---|
Upper Control Limit (UCL) and Lower Control Limit (LCL) - mandatory | Number input defining the upper and lower control limit used for evaluating the control chart rules. The UCL must be larger than the LCL. |
Center Line | Configuration of the center line used for evaluating the control chart rules. If "Middle Center Line" is selected, the average of the UCL and LCL will be used. If "Custom Center Line" is selected, the user can specify any value between the UCL and LCL. |
Rule Selection - at least one must be selected | Configuration of the rules to be evaluated by the Control Chart Layer to generate insights. See rule description below. |
Automatically identifies appropriate boundaries for single outlier detection based on the currently visible data and an acceptance range (6 sigma equivalent). Upon initially selecting this option, the limits are automatically calculated.
Option | Description |
---|---|
Calculate Limits (button) | Recalculates the limits based on the currently visible data. Below the settings, the time since the last calculation and related timestamp are shown. |
Rule Selection - not changeable | For the calculated limits, only the Single Outlier rule can be selected. |
The following rules are available:
Rule Name / Insight | Logic | Visualization |
---|---|---|
Single Outlier | Any single data point above the Upper Control Limit (UCL) or below the Lower Control Limit (LCL). | Outliers are visualized with a red outline in the chart. |
Prominent Shift | 9 or more consecutive data points either entirely above or entirely below the center line. | Prominent Shifts are visualized by a red background highlight in the chart. |
When the control chart is active, alerting can be activated in the Alerts panel. This can be accessed using the "Alerts" button in the top right corner of the analytics editor.
When alerting is turned on, Tulip will automatically check for new insights in the background every hour and send an email the the users specified in the "Recipients" list in the Alerts panel.
The email contains:
The Forecast layer in Tulip’s Analytics Builder provides out-of-the-box forecasting for time-series data. The layer uses machine learning to evaluate the existing data in you analysis to predict and visualize a likely future development of that data as a 95% confidence interval.
This layer can be added to Tulip Table analyses with the following configuration:
Once a chart configuration is fulfilling these requirements, the Forecast Layer will be available in the Chart Layers panel. This can be opened by clicking on the Chart Layers button in the top right corner of the analytics editor.
The following configuration options are available:
Option | Description |
---|---|
Forecast Strategy | There are three forecast strategies available. Selecting the right one for your use case can improve your forecast quality. |
Prediction Period | The number of days to be shown as a forecast. |
Show estimated trend | Toggles showing a line depicting the trend that is estimated by the forecasting model. |
Evaluate Forecast | Triggers a quality evaluation for the forecast, which shows:
|
The trendline layer adds a linear trend line to charts in Tulip Analyitcs. It can be added to Tulip Table analyses with the following configuration:
Once a chart configuration is fulfilling these requirements, the Trendline Layer will be available in the Chart Layers panel. This can be opened by clicking on the Chart Layers button in the top right corner of the analytics editor.
There are no additional settings avaialbe for the trend line layer.
ID | Name |
---|---|
QA-T101 | Analytics - Table Analytics |
QA-T134 | Record Placeholders : 08 - Delete Record Placeholder |
QA-T208 | Analytics - Analytics Widget |
QA-T259 | Analytics - Machine Analytics |
QA-T280 | Analytics - Analytics Widget Filtering |
QA-T281 | Analytics - Analytics Widget Filtering (Machine-based) |
QA-T353 | Analytics Template - Single Number |
QA-T354 | Analytics Template - One Operation |
QA-T355 | Analytics Template - Compare Variables |
QA-T356 | Analytics Template - Multiple Axes |
QA-T357 | Analytics Template - Table |
QA-T358 | Analytics Template - Slideshow |
QA-T359 | Analytics - Analytics Sharing |
QA-T360 | Analytics - Analytics Copying |
QA-T361 | Analytics - Analytics Refresh Rates |
QA-T473 | Schedules and Shifts : 03 - Applying shifts in analytics |
QA-T927 | Table Analytics - Filtering by 'Date Range' settings |
QA-T962 | Analytics - Analytics Widget (cloned) |
QA-T963 | Analytics - Analytics Widget Filtering (Machine-based) (cloned) |
QA-T964 | Analytics Template - Single Number (cloned) |
QA-T965 | Analytics Template - One Operation (cloned) |
QA-T966 | Analytics Template - Compare Variables (cloned) |
QA-T967 | Analytics Template - Multiple Axes (cloned) |
QA-T968 | Analytics Template - Slideshow (cloned) |
QA-T969 | Analytics - Analytics Copying (cloned) |
QA-T970 | Analytics - Analytics Refresh Rates (cloned) |
QA-T971 | Analytics - Analytics Widget Filtering (cloned) |
QA-T972 | Analytics - Analytics Sharing (cloned) |
QA-T974 | Analytics Template - Table |
QA-T975 | Advanced Analytics : 01 - Control Chart Layer |
QA-T977 | Advanced Analytics : 03 / Red Tabs (cloned) |
QA-T978 | Advanced Analytics : 01 / Control Chart Layer (cloned) |
QA-T980 | Analytics - Machine Analytics (cloned) |
QA-T981 | Analytics - Table Analytics (cloned) |
QA-T985 | Advanced Analytics : 02 - Forecast |
QA-T987 | Advanced Analytics : 02 / Forecast |
QA-T988 | Advanced Analytics : 03 - Trend Line |
ID | Requirement |
---|---|
PLAT-8728 (249) | Provide the ability to print the material history record |
PLAT-8733 (246) | All tracked information must be available for reporting |
PLAT-8739 (463) | Ability to browse (view and display) forward and backwards batch/lot and material genealogy at all level of the material tracking hierarchy. |
PLAT-8742 (247) | All tracked information must be available for visualization |
PLAT-8746 (104) | All tracked information must be accessible and viewable for users in a workflow. |
PLAT-8749 (61) | Data from connected end-points can be visualized in graphical format such as gauges, indicator, dial, scales, etc. |
PLAT-8751 (60) | Data from connected end-points can be visualized as simple metrics |
PLAT-8790 (245) | All tracked information must be available for analysis |
PLAT-8795 (833) | Abillty to view and perform analysis on all captured data, including audit trail and annotations |
PLAT-8796 (832) | Ability to view and perform analysis on audit trail data |
PLAT-8800 (464) | Ability to perform analysis on batch/lot and material history records. Ie query history records based on any attribute of the material |
PLAT-8832 (242) | Ability to retrieve all historized information for a specific equipment with date-time filters |
PLAT-8844 (372) | Track the real-time status of all equipment instances |
PLAT-8860 (97) | Visibility to equipment allocation during work order and batch/lot execution to determine future equipment availability during dispatching activities |
PLAT-8875 (831) | Ability to manage an authorized change of Digital History Record with full audit trail |
PLAT-8876 (427) | Ability to track material attributes during production operations with associated capabilities to browse their history and their trending e.g. temperature, assays, etc. |
PLAT-8884 (95) | Ability to view material information for a batch/lot in an App. Information includes all material as part of a material hierarchy, ie. cohort, plate, well, etc.) |
PLAT-8919 (407) | Ability to track of material waste and scrap as part of the production process execution. |
PLAT-8967 (76) | Ability for content to display relevant process and production data in either graphical format. Ie. pareto, bar graphs, pie graph |
PLAT-8973 (352) | All tracking history information must be retained for historical review and analysis for a configurable retention period |