To best utilize Table Analytics, first read and understand how to use Apps to Modify Tables, and how to use the Analytics Builder.

Analytics are a powerful way to display data collected on the shop floor. App-based Analytics are great for analyzing historical data. Table-based Analytics can be created in order to reflect the current state of a Table's fields and values.

Creating a Table Analysis

Navigate to the Dashboards page to create a new analysis.

From the Add Analysis options, select the Table option for the analysis, then select the desired Table to analyze.

Once selected, click Add New Analysis.

The rest of the Analytics Builder will appear the same, but give options based on the current state of the table. The Following options are present for Table Analytics:

Important Note: Date Range refers to the date and time the record was created.

Example 1 - Percent of Work Order Completion

In a table, you might store updated information on orders for the quantity ordered and quantity built. In a case such as this, a Table analysis can easily display these values. For example, the current state of the table might look something like this:

To analyze this data, you might want to see the current progress of these orders. To reiterate, the Analysis should be filtered to match the Date Range you are interested in based on when the ID was created in this table.

The X axis most usefully will display the name of the order, stored as the ID field.

The Y axis can then be made to compare the two number values of interest using an expression.

Here, the expression is simply dividing the number of made parts by the ordered value. It is then converting that number to a percentage.

This analysis will look something like this:

Example 2- Count of Statuses

You may want to check the current status of work orders. In this example, your work order status table might look something like this.

A count of the current statuses can be found most easily by setting the X axis to the Status field.

With Status selected, the Y axis should provide a count for how many records are in each Status. It might also be helpful to only provide the count where a value exists. To accomplish both at once, add a Count Where True aggregation to the Y axis. This will look something like this:

From here, you could provide more granular data by adding a Compare By field, perhaps based on the ID.

The outcome of this tracker will look something like this once completed:

Further Reading

Did you find what you were looking for?

You can also head to to post your question or see if others have faced a similar question!

Did this answer your question?