How to Control Grouping

Table views are useful when you have lots of data to display because they allow you to sort and group your data.

Grouping

A deck or table view can group records under headings. To create a grouped view:

1. Go to the UX >> Views tab.
2. Create a deck or table view.
3. Use Group by to select a single column to group your data by.

  Multi-level "Drilldown"

A view can group records in a multi-level "drilldown" view.

To create a multi-level grouped view:

1. Go to the UX >> Views tab.
2. Create a deck or table view.
3. Use Group by to select two or more columns to group your data by. You can group by as many columns as you wish by pressing the + button. Press the X button to remove grouping columns.

Note: If you don't want a grouping header on the final level of grouping, add the _RowNumber column as the final grouping column. This makes it easy to select a group from the list.