Analyse data by grouping columns
When you are displaying your data in the Data Display window, you can use a function of the grid to automatically group your data by particular columns.
If you select View > Group-by Box (or Ctrl+G) AQT will display a Group-By box at the top of the display. This allows you to group your data by particular columns; this function is extremely useful for analysing your data.
- If you drag a column to the group-by box, the data will be grouped by that column. You can group-by multiple columns.
- You can expand or collapse sections of the group hierarchy by clicking on the + or – icons or double-clicking the item.
- View > Collapse Rows / Expand Rows will collapse or expand the group hierarchy.
- If you are grouping by multiple columns, Collapse/Expand will just collapse or expand the top column in the grouping. You can also use View > Collapse All or Expand All to collapse / expand all groups in the hierarchy.
- You can expand or collapse the grouping by double-clicking the column in the Group-By box. Note that if you expand a column, but one of the higher-level column is collapsed, you will not see the expanded data. The columns at the higher levels will also need to be expanded.
- You can removing the grouping by dragging the column and dropping it onto the grid (ignore the large X that you see when you do this).
Once you have grouped your data, you can calculate sub-totals on the data.