Skip to main content
Skip table of contents

Creating new aggregated columns

For some types of reports, you can create any number of custom aggregated (summary) columns. An aggregated 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 aggregated 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 aggregated 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 aggregated column options

Supported types of reports for aggregated columns

The aggregated (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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.