Advanced Analytics - Making your Widgets Interactive

Owned by Henry Yiu
Last updated: Jun 02, 2023 by Aadesh Srivastav (Unlicensed)
3 min read

Advanced Analytics includes premium widget functionality where users can interact directly with the widgets to dig into the data set without having to create a brand new widget. This can save time and help users design widgets with more simplicity.

Drill-In

Drill-In is a powerful feature that allows users to dynamically graph a new grouping option to dive deeper into different dimensions of your data set without having to create a brand new widget.

  1. Right-click on any point in the widget into which you want to drill down

  2. If you have already drilled into this chart, then you will have shortcuts to previously selected fields, or select Choose Another Field to select a different field for the first time.

This will allow the other data fields to drill Into for your grouping:

For example - if you are selecting an OEE percentage you may wish to break this day by shift. There will be a new widget displaying the drill-in selection.

To clear the Drilled selection and return to the original display; click on the close box in the upper left corner of the “Drilled-In” graph

Your graph will return to it’s original form.

  • The data fields must be related and join somehow to your selection in order to make sense of the data. If the data field is not joined or unrelated you will not get any results and it may result in an error

  • Multiple Drill-In layers are possible

  • Drill down are not available for indicator widgets, Calendar heatmap and Area Map

  • Drill down is not available when ‘break by’ is used in a graphing

Interactive Pivot

Pivot tables are very powerful in displaying data sets and aggregating numbers. Interactive pivot is a feature that allows dynamic additions and removals of columns/rows to aggregate results without creating a brand new pivot table or adding subtotals to your data set.

Interactive Pivot can be enabled on tables in the Design section of widget:

 

Example - You may have a pivot table with daily Unit data

You may want to aggregate the data by Month without creating a new pivot table. Interactive pivot would allow users to remove fields - for example the Calendar column:

New Aggregated table through interactive pivot:

This column could be added back in by right clicking in the table:

General Limitations

  • Please note in order to add a column field the corresponding field must enabled while the creating the pivot report at first

  • When the widget is on to a drill state – it does not allow to remove columns and rows