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
...
Your graph will return to it’s original form.
...
Drill-In Data set requirements
...
|
...
|
...
|
| Anchor | ||||
|---|---|---|---|---|
|
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:
...
...
| Anchor | ||||
|---|---|---|---|---|
|
...
This column could be added back in by right clicking in the table:
...
| Info |
|---|
General Limitations
|
...
|
...
|