Skip to main content
All CollectionsFAQsKPIs
What is an aggregation type?

What is an aggregation type?

The differences between the aggregation types for custom KPIs

Updated over a month ago

This feature is included with Fathom Pro - the plan with access to all of Fathom's features. Companies on Portfolio can be upgraded to Fathom Pro at any time.

When you create a custom KPI, the 'aggregation type' determines how targets and non-financial KPI results roll up to quarterly and annual periods.

For monthly targets and non-financial KPI results:

  • Average: The quarterly and yearly results are the average of the non-financial results or target values for the period
    ​

  • Sum: Adds up all of the non-financial results or target values for the period
    ​

  • Balance: Chooses the last month's target or non-financial result as the value for the quarter or year

For KPIs that include financial and non-financial variables, each variable will be aggregated according to:

  • Non-financial KPI results: Will be aggregated according to the aggregation type selected for the non-financial KPI.
    ​

  • P&L Results: Profit & Loss, or Income Statement, KPIs are summed for the quarterly or yearly results.
    ​

  • Balance Sheet Results: Quarterly and yearly results for Balance Sheet KPIs are determined by the ending balance for the KPI.

Learn more

Did this answer your question?