Aggregation types
UNIQUE COUNT
The unique count aggregation type counts only the unique values of a specified event property.

UNIQUE COUNT calculation method
UNIQUE COUNT billable metric
Dashboard
API
Here is how you can create a unique count aggregation from the UI:
- Access the “Billable metrics” section via the side menu;
- Create a new billable metric;
- Define a name, a code and an optional description;
- Select “count unique” as the aggregation type;
- Define it this metric is
metered
orrecurring
; - Define the property to aggregate;
- Apply dimension groups if any; and
- Click “Add billable metric”.
This billable metric can be both metered
or recurring
.
Calculation example
Lago calculates the COUNT_DISTINCT(events.properties.property_name)
for the two following events received.
//Event received #1
{
"transaction_id": "transaction_1",
"external_customer_id": "1",
"timestamp": "2022-03-16T00:00:00Z",
"code": "api_requests",
"properties": {
"request_id": "id_1"
}
}
//Event received #2
{
"transaction_id": "transaction_2",
"external_customer_id": "1",
"timestamp": "2022-03-17T00:00:00Z",
"code": "api_requests",
"properties": {
"request_id": "id_1"
}
}
In that case, with this aggregation type, Lago only counts the unique values request_id
property in the event payloads, resulting in a billable value of 1 unit.