Service Titan Knowledge Base

Aggregate report dataLast updated on 09/09/2022

Use column aggregation tools to calculate details about specific report columns like column totals, column averages, total number of entries, total number of unique entries, or maximum and minimum values for items in a column.

For example, you can set column aggregates so that every time you run a jobs report, you immediately see the total number of different customers, the largest invoice subtotal, and the average income earned per job. These metrics can provide a quick snapshot of your business performance.

Things to know

  • The available aggregation calculations for a column are based on the data type. For example, for a column of text entries like customer name, the Average and Sum calculation options are not available.

  • Column aggregation settings are retained when you save a report.

  • True/False metrics (like the Converted report column in the Jobs template) will always display the count of total report rows and are not expected to display the count of only 'True' values.

  • Click Export above your report results and select Export only aggregated data to download just the aggregate values of your report.

Add column aggregation calculations

To add column aggregation calculations to a report:

  1. Run a report.

  2. Click the dropdown at the bottom of the columns you want to aggregate and select a calculation:

    • Count—Total number of entries

    • Count Distinct—Total number of unique entries

    • Sum—Sum of values

    • Average—Sum of values divided by the number of entries

    • Minimum—Smallest numerical value

    • Maximum—Largest numerical value

    • None—Remove aggregation calculation

  3. When you’re done selecting calculations, click Run Report. The aggregate results appear at the bottom of the columns you added calculations to.

  4. Click Save Changes to use these aggregate settings the next time you run the report.

Want to learn more?

Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.

Disclaimer: Information provided in this article is for informational purposes only and it should not be construed to be legal advice. Information provided in this article may also not constitute the most up-to-date legal or other information. You should not act or refrain from acting on the basis of any information in this article to meet any compliance requirements without seeking independent legal or other professional advice.