Analysis
An Analysis is a visual display of data from the following data sources within Tulip
- App (single or many)
- Table (single)
- Machine (single or many)
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:
- A “Chart Template” that determines the type of display- bar chart, table etc.
- A set of configuration fields and their current values. The available configuration fields depend on the Chart Template.
This doc will review all the possible configuration fields for each chart template and data source combination.
Fields For All Chart Templates
| 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 analysis Download 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 |
| Compare By | A categorical value that will determine if the baars should be split up by different colors |
| Date Range (apps only) | The date range for values that will be considered in this chart based on when the app completion with the data point occurred |
| Filters | Any exclusion or inclusion rules for data in this chart |
| Table (table data source only) | The table data source for the analysis |
| Date Range (tables only) | The date range for values that will be considered in this chart based on when the table row was created |
| Machine (machine data source only) | The machines under a specific machine type that will be considered in the analysis |
| Date range (machine data source only) | The date range for values from OPC tags that should be considered based on when the OPC tag outputted a value |
| Display | A series of options to change the display of data on the chart, including:
Show Target Cycle Time: Show the goal process cycle time from the first app added to the Analysis Switch X Axis and Colors: Switch the “Compare By” and “X Axis” values Hide Legend: Hide the legend on top of the chart Hide X Axis Label Hide X Axis Tick Labels Hide Y Axis Tick Labels |
| Customize | Change the way that names of different variables, table data, machine data, and summary operations appear on the chart |
One Operation
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 |
| Display | Chart Types
Bar Chart, Donut Chart, Line Chart, Pareto Chart, Dot Plot |
Compare Variables (bar chart)
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 (apps data only) | Choose the variables with numerical or boolean values that you would like to compare on the chart |
| Y Axis | The numerical values that you would like to compare on the chart |
| Display | Chart Types
Stacked Bar Chart Grouped Bar Chart Multiseries Line Chart Grouped Dot Plot |
| X Axis (table data only) | Choose the table fields with numerical or boolean values that you would like to compare on the chart |
| X Axis (machine data only) | Choose the machine fields with numerical or boolean values that you would like to compare on the chart |
Multiple Operations (bar chart)
This displays multiple numerical or boolean variables or table fields on the X axis and up to 2 numerical Y axes. Only the Y axis related to the first defined operation will be shown.
| Name | Description |
| X Axis (apps data only) | Choose the variables that you would like to compare on the chart |
| Compare | Choose the 2 different Y axes that you would like to show on the chart |
| Display | Chart Types
Stacked Bar Chart Grouped Bar Chart Multiseries Line Chart |
| X Axis (machine fields only) | Choose the machine fields that you would like to compare on the chart |
Results on X Axis (bar chart)
This shows individual app completions on the X axis and a numerical or boolean value on the Y Axis.
| Name | Description |
| Y Axis | The list of numerical variables or table fields to compare for each individual app completion |
| Display | Chart Types
Bar Chart, Donut Chart, Line Chart, Pareto Chart, Dot Plot |
Scatter Plot
This shows one numerical table field or variable on the x axis and a numerical value on the Y axis.
| Name | Description |
| X Axis | Choose the variables with numerical values that you would like to compare on the chart X axis |
| Y Axis | Choose the variables with numerical values that you would like to compare on the chart Y axis |
| Sorting | The direction of the X axis- either values are either increasing or decreasing
Also includes a “limit” input to limit the number of data points on graph |
| Display | Chart Type
Table |
Single Number
This shows a single numerical value. Can be whole number or percentage.
| Name | Description |
| Number (app data only) | Specify the numerical value that should be displayed |
| Number (table data only) | The numerical value that should be shown based on a single value from a Table Row or a rollup value from multiple Table Rows |
| Number (machine data only) | The numerical value derived from a rollup of many Machine State Changes |
Slideshow
This shows a single Image variable or table field with any user-defined text variables or table fields alongside it. There is one “slide” in the “slideshow” per app completion.
| Name | Description |
| Image | Determines which image variable should be used in each step of the slideshow |
| Columns | Additional data points from the app completion that should be shown alongside the image in the slideshow |
Tables
Tables show single rows of data per app completion OR rows for each value of a user-defined variable in the “Groupings” section. For example, one row per user.
| Name | Description |
| Groupings | Determines what should make up a row in the table- either individual values from app completions or common values across many app completions |
| Operations | The columns that should be shown for each grouping- can be numerical or categorical |
| Sorting | The order of rows- can be based on a numerical value in any column
Also includes a “limit” input to limit the number of data points on graph |
Tests
| 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 |
Requirements
| ID | Requirement |
|---|---|
| 60 | Data from connected end-points can be visualized as simple metrics |
| 61 | Data from connected end-points can be visualized in graphical format such as gauges, indicator, dial, scales, etc. |
| 76 | Ability for content to display relevant process and production data in either graphical format. Ie. pareto, bar graphs, pie graph |
| 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.) |
| 97 | Visibility to equipment allocation during work order and batch/lot execution to determine future equipment availability during dispatching activities |
| 104 | All tracked information must be accessible and viewable for users in a workflow. |
| 242 | Ability to retrieve all historized information for a specific equipment with date-time filters |
| 245 | All tracked information must be available for analysis |
| 246 | All tracked information must be available for reporting |
| 247 | All tracked information must be available for visualization |
| 249 | Provide the ability to print the material history record |
| 352 | All tracking history information must be retained for historical review and analysis for a configurable retention period |
| 372 | Track the real-time status of all equipment instances |
| 407 | Ability to track of material waste and scrap as part of the production process execution. |
| 427 | Ability to track material attributes during production operations with associated capabilities to browse their history and their trending e.g. temperature, assays, etc. |
| 463 | Ability to browse (view and display) forward and backwards batch/lot and material genealogy at all level of the material tracking hierarchy. |
| 464 | Ability to perform analysis on batch/lot and material history records. Ie query history records based on any attribute of the material |
| 465 | Ability to query history records by any related dimension. Ie. equipment, user, work order, material, time, duration, etc. |
| 831 | Ability to manage an authorized change of Digital History Record with full audit trail |
| 832 | Ability to view and perform analysis on audit trail data |
| 833 | Abillty to view and perform analysis on all captured data, including audit trail and annotations |