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.
| Anchor | ||||
|---|---|---|---|---|
|
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.To access Drill
Right-
...
click on
...
any point in the widget into which you want to drill down
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.
...
| Info |
|---|
|
| Info |
|
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
...
...
Drill-In Data set requirements
|
...
|
...
Interactive Pivot
...
|
...
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:
...
Limitations
...
|
| Anchor | ||||
|---|---|---|---|---|
|