Aggregation types
Overview
Aggregation types will define how consumption will be measured.
Here is the full list of aggregation types officially supported by Lago.
| Aggregation | Description | Transcription |
|---|---|---|
| COUNT | Count the number of times an incoming event occurs | COUNT(events.code) |
| COUNT UNIQUE | Count the number of unique value of a defined property for incoming events | COUNT_DISTINCT(events.properties.property_name) |
| LATEST | Get the latest value of a defined property for incoming events | LAST_VALUE(events.properties.property_name) OVER ([PARTITION BY events.timestamp]) |
| MAX | Get the maximum value of a defined property for incoming events | MAX(events.properties.property_name) |
| SUM | Sum a defined property for incoming events | SUM(events.properties.property_name) |
| WEIGHTED SUM | Sum a defined property for incoming events, prorated based on time used per period | SUM(events.properties.property_name) / (DATEDIFF(SECOND, timestamp.event_1, timestamp.event_2) + 1) * (DATEDIFF(SECOND, 'period_start', 'period_end') + 1) |
| CUSTOM | Define a custom code for your aggregation | Custom code |
Except the
COUNT (that is counting the number of times an event occurs), the
other types aggregate over a single property of the event. The result of this
aggregation will be used to charge your customers.Aggregation types
Overview
Aggregation types will define how consumption will be measured.
Here is the full list of aggregation types officially supported by Lago.
| Aggregation | Description | Transcription |
|---|---|---|
| COUNT | Count the number of times an incoming event occurs | COUNT(events.code) |
| COUNT UNIQUE | Count the number of unique value of a defined property for incoming events | COUNT_DISTINCT(events.properties.property_name) |
| LATEST | Get the latest value of a defined property for incoming events | LAST_VALUE(events.properties.property_name) OVER ([PARTITION BY events.timestamp]) |
| MAX | Get the maximum value of a defined property for incoming events | MAX(events.properties.property_name) |
| SUM | Sum a defined property for incoming events | SUM(events.properties.property_name) |
| WEIGHTED SUM | Sum a defined property for incoming events, prorated based on time used per period | SUM(events.properties.property_name) / (DATEDIFF(SECOND, timestamp.event_1, timestamp.event_2) + 1) * (DATEDIFF(SECOND, 'period_start', 'period_end') + 1) |
| CUSTOM | Define a custom code for your aggregation | Custom code |
Except the
COUNT (that is counting the number of times an event occurs), the
other types aggregate over a single property of the event. The result of this
aggregation will be used to charge your customers.