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:
- Go to the UX >> Views tab.
- Create a deck or table view.
- 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:
- Go to the UX >> Views tab.
- Create a deck or table view.
- 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.