Grouping collapses the Log View into one row per value, with a count, so you can see the shape of the activity before you read any individual record. Group by Changed By to see who is busiest. Group by Entity to see which tables are generating the most audit data.

Group by a column

1. Select Columns on the right edge of the Log View.
2. Find Row Groups below the column list.
3. Drag a column from the list into the area marked Drag here to set row groups.

Figure 1. The Columns panel open, showing the column checkboxes and the Row Groups drop zone used to group the grid.

The grid collapses immediately. Each group shows its value and how many records it contains, and Total Records at the bottom shows both the record count and the number of groups.

Figure 2. The Log View in grouped mode, with audit records collapsed into one group per user and a record count on each group.

The column you grouped by moves out of the grid and into the Group column, so its checkbox clears in the column list. That is expected. Removing it from Row Groups puts it back.

Read a group

Select the arrow at the start of a group row to expand it and see the individual audit records inside. Select it again to collapse the group.

Figure 3. A group expanded in the Log View, showing individual audit records with Changed Date, Event, Record, Entity, Entity Schema Name and Operation.

Total Records at the bottom shows the number of records and the number of groups.

Remove grouping

Each grouped column appears as a chip in Row Groups. Select the cross on that chip to remove it. With no chips left, the grid returns to a flat list of individual records.

Group by more than one column

Drag a second column into Row Groups to group inside the groups, for example Entity and then Operation. Expanding an entity then shows its activity broken down by what was done.

Figure 4. The Log View grouped by two columns, with Entity and Operation shown as chips in the Row Groups area.

The order of the chips is the order of the grouping. Use the arrow on a chip to move it, which changes which column is the outer group and which is the inner one.

Which column to group by

You want to know Group by Who is generating the most activity Changed By Which tables produce the most audit data Entity The balance of creates, updates, deletes and reads Operation

Tip

Grouping and filtering work well together. Filter to a single day first, then group by Changed By, and you have that day's activity per user in a few seconds.