properties
field.
WHERE
and GROUP BY
SQL clauses respectively. For example, you can create a billable metric for the COUNT()
of API calls based on the following usage based event
COUNT()
to count the number of events that meet the filter constraintsMAX(property)
to get the maximum value of the property for events that meet the filter constraintsSUM(property)
to get the sum of the property for the events that meet the filter constraintsUNIQUE(property)
to get the count of the number of unique values for the property for events that meet the filter constraintsAVG(property)
to get the average of the property for the events that meet the filter constraintsUnique Count(property)
to get the unique count of the property for the events that meet the filter constraintsLast Reported In Period(property)
to get the last reported value of the property in a time period for the events that meet the filter constraintsLast Reported In History(property)
to get the last reported value of the property for the events that meet the filter constraintsHistorical Sum(property)
to get the historical sum of the property for the events that meet the filter constraints