The sum aggregation type adds up the value of a defined event property.

SUM calculation method

SUM billable metric

Here is how you can create a sum aggregation from the UI:

  1. Access the “Billable metrics” section via the side menu;
  2. Create a new billable metric;
  3. Define a name, a code and an optional description;
  4. Select “sum” as the aggregation type;
  5. Define it this metric is metered or recurring;
  6. Define the property to aggregate;
  7. Apply dimension groups if any; and
  8. Click “Add billable metric”.

This billable metric can be both metered or recurring.

Calculation example

Lago calculates the SUM(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": {
        "total_requests": 20
    }
}

//Event received #2
{
    "transaction_id": "transaction_2",
    "external_customer_id": "1",
    "timestamp": "2022-03-17T00:00:00Z",
    "code": "api_requests",
    "properties": {
        "total_requests": 10
    }
}

In that case, with this aggregation type, Lago adds up the values of the total_requests property in the event payloads, resulting in a billable value of 30 units.