Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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
drill
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.To access Drill

  1. Right-

...

  1. click on

...

Select the “Choose Another…” selection.

  1. 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.

...

info
Info
  • 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

...

...

Your graph will return to it’s original form.

...

Drill-In Data set requirements

...

  • 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

Anchor
pivot
pivot
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.

...

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

...

Info

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