Tulip users commonly need to analyze data from Tables for two reasons:
- Traceability or genealogy requirements
- Production data, ie length of time to complete a specific work order
Here's how to analyze data from table records that are stored when an app is completed.
Tulip currently recommends that you use app completion data to analyze data from Tables. You could certainly store many values in a single table record, but that is often cumbersome. Instead, you can use app completion data to analyze loaded records alongside all variable values in the app at the time of completion.
Viewing Records Loaded In Every App Completion
You may want to know which records were loaded each time the app was completed. This links a work order stored in a record to the app completion where it was modified.
To do this, go to the App Summary View and select the “Completions” tab.
Scroll to the right, and you should see a column for each record placeholder in the app.
Click the link in blue to see the full summary of the record with that particular ID at that time. This means that all values for that table record were saved alongside the app completion data.
For example, if you were creating a chemicals product, and you wanted to know the lot number of every ingredient, you would use the "Completions" tab to see a combination of the active batch and the lot numbers that were entered by the operator.
Viewing Table Data in Analytics
You can analyze the records that are loaded into an app when it is completed.
So, let’s say that you have an app that logs defects and updates a “Defect Reports” table. This “Defect Reports” table has a column called “Type” which lists the type of defect. You want to analyze the most common types of defects across all app completions.
To do this, go to the Analytics Builder and choose the “One Operation” template. Then, you will need to change the “X Axis” option to the field in the table that is being changed every time an operator uses the app.
Under X Axis, select the option and choose “Table records”.
Then, choose the field where you would like to analyze the values at time of app completion.