For some types of reports, you can create any number of custom aggregate (summary) columns. An aggregate column can display either the sum or the average of a selection of any number of other columns available for the type.

To create a new aggregate column for a report:

  1. Go to MyQ, Reports. On the list of reports on the right side, select the report and click Edit on the ribbon (or right-click, edit). The report properties panel opens on a new window.

  2. Go to the Design tab on the properties panel.

  3. In the Table section, click +Add, and select +Add aggregated column from the list. The properties panel of the new column opens.

    Adding a new aggregate column
  4. In the panel, set the properties, select the Aggregate operation you want to use (Sum or Average), and click Save. The new column is listed with the other table columns, and you can double-click on it to edit it.

    New aggregate column options

Supported types of reports for aggregate columns

The aggregate (summary) columns can be created for the following types of reports:

  • From the Groups category: Monthly summary, Total summary

  • From the Print jobs category: Expired and deleted jobs

  • From the Printers category: Daily summary, Day of the week, Meter reading via SNMP, Total summary

  • From the Projects category: Daily summary, Day of the week, Monthly summary, Project groups total summary, Projects per user, Users per project.