Grouping and summarizing report data

You can group report data by columns or rows you select, to help you better understand the data. You can also set reports to automatically display the sum, average, maximum, minimum, or count of data in a column.

Grouping report data by row or column

You can group report data by select columns that display in each report. Columns can be grouped by row or by column.

Example of grouping by row

In the Project Team Billing report, if you group data by Project Name, then by User Name, and then by Year (Entry Date):

The report would look like this:

Example of grouping by column data

In the Time Off Taken report, if you group data by Time Off Type, and Time Off Taken (Days) is set to sum:

The report would look like this, with each time off type having its own column:

Setting up data grouping

To group report data:

  1. Go to Reports, and open the report whose data you want to group.
  2. Click the Settings button.

The Reports Settings dialog displays.

  1. In the Grouping section at the bottom of the dialog, select a field to group by from either the Group Rows or Group Columns section, as applicable.

  1. If you want to group by more than one field, click the icon and select an additional field.
  2. Click Done.

Columns you group by will display first in the report, regardless of where they display in the Report Settings dialog.

Summarizing report data in a column

For any summable fields in a report, you can set the report to automatically calculate an average or sum for all values in that column, or display the minimum or maximum value listed in that column.

A count option is also available for certain fields, like User Name. The count total will show the number of unique entries that display in that column (for example, the number of unique user names).

Setting up data summaries

To set up automatic summary of a column's data:

  1. Go to Reports, and open the report for the column you want to summarize.
  2. Click the Settings button.

The Reports Settings dialog displays.

For each report column that has summary options available, a drop-down displays in the Summary Options column.

  1. Click a drop-down for a column, and select a summary option.

  1. Click Done.

Viewing summarized data in reports

Summarized data (for example, the sum or average) displays in a dark gray row at the bottom of the report. The sum or average for any data groupings you’ve set up will also display.

For example, in the following report, the Time Off Taken (Days) field is set to sum, so the sum of all days taken for all users shows in the bottom row of the report table. Plus, this report is grouped by User Name, so the total days taken for each user displays in each gray user row.

Expanding and collapsing report data

If summary options have been set up in a report, an Expand/Collapse toggle will be available under the report’s filter fields.

If you click Collapse, the report will collapse so only the summary rows or columns display.

In the expanded state, all data displays.

FAQs

Can we group or summarize by custom report fields?

Yes, you can group or summarize by custom fields.