In “Create View” mode, the View Wizard allows users to specify two levels of grouping for the data to be summarised by:
Once the View has been saved, “Edit View” mode allows any number of groupings to be applied to the data:
- Dimension – The field by which the data is to be grouped by
- Sort Order – Whether the data should be sorted in Ascending or Descending Alphanumeric order (See Measures to order by data values)
- Grouping Interval – Only available for date fields. Allows data to be grouped by Date, Month or Year.
- Delete – Removes this Grouping
Data Groupings will be used to drill into the data in the order in which they have been created (e.g. Group 1 > Group 2 > Group 3 > Line Level Data)