Quick measures
Quick measures allow you to convert a dimension into a measure by applying an aggregation function. To learn more about dimensions and measures, see Dimensions and measures.
An aggregation summarises multiple values into a single result, such as calculating a total, average, or count. This allows you to analyse dimension values directly in your report without creating a custom field.
This guide explains which aggregations are supported and how to apply them.
In this article
Supported aggregations
The following aggregations can be applied as quick measures:
- SUM: Adds all values together
- AVERAGE: Calculates the mean value
- MINIMUM: Returns the lowest value
- MAXIMUM: Returns the highest value
- SINGLE: Returns a value when only one exists
- COUNT: Counts all values
- COUNT DISTINCT: Counts unique values
Example:
Apply a quick measure using the MAXIMUM aggregation to the Total price field to show the highest order value for each customer.
This returns the largest order placed for each customer.
⚠️ Applying quick measures to dimensions from related tables
Quick measures should be applied with caution to dimensions from related tables.
Applying aggregations such as SUM or AVERAGE to these fields can result in inflated or inaccurate totals.
Why this happens
When a report's root table has a many-to-one relationship with a related table, values from the related table can be repeated across multiple rows in your report.
If these repeated values are aggregated, they are counted multiple times.
Example:
Sales data is stored in the Agreement lines table, while inventory data is stored in the Product variants table.
- The Product variants table contains one row per variant
- The Agreement lines table contains multiple rows for each sale or refund of a variant
When you create a report based on the Agreement lines table and add a field such as Inventory quantity from the Product variants table, the same value is repeated across multiple rows. If you then apply SUM to the Inventory quantity field, these repeated values are added together, resulting in an inflated total.
Apply a quick measure
- Select Edit in your report
- Drag the dimension you want to summarise into the Selected measures pane
- To change the aggregation:
- Select the measure to open the field editor
- In the Aggregation dropdown, select a function
- Select OK
Need more support?
If you get stuck or have additional questions, you can contact our team directly through the Help widget in the bottom-right corner — we typically respond within one business day.