Aggregate Data in a Company Single Tool Report

To set up data aggregation on a company single tool report.

You can apply data aggregation functions to the columns in a single tool report. Available functions include: Count, Sum, Min, Max, and Average.

• Required User Permissions:

  • 'Admin' level permissions on the Company 360 Reporting tool
    AND

  • 'Admin' level permissions on the Procore tool being used for the report's source data.

1. Navigate to the Company 360 Reporting tool.

2. Locate the report in the Reports tab.

3. Click the vertical ellipsis (⋮) and choose Edit.
   
   
   

4. Open the Group By menu and choose one of the listed options.

5. Click the fx symbol in the report's column. Then choose one of the available aggregate functions from the drop-down menu:
   Note: The option(s) that are available depend upon the type of data in the selected column. Field types that are not a numeric value only have the option to aggregate the data by count.

   • Count. The total number of records in the selected column.

   • Sum. The total of all values in the selected column.

   • Min. The minimum value in the selected column.

   • Max. The maximum value in the selected column.

   • Average. Uses the sum to calculate the average value in the selected column.

6. Click Update Report.

Once the report is created, you will see the Count, Sum, Min, Max, or Average of the values at the bottom of the column.