query_segmentation_sum
Sum numeric expressions for events over time in Mixpanel to calculate revenue metrics, track cumulative totals, and aggregate quantitative values across specified time periods.
Instructions
Sum a numeric expression for events over time. Useful for calculating revenue metrics, aggregating quantitative values, and tracking cumulative totals across different time periods.
Input Schema
Name | Required | Description | Default |
---|---|---|---|
event | Yes | The event that you wish to get data for (single event name, not an array) | |
from_date | Yes | The date in yyyy-mm-dd format to begin querying from (inclusive) | |
on | Yes | The expression to sum per unit time (should result in a numeric value) | |
project_id | No | The Mixpanel project ID. Optional since it has a default. | |
to_date | Yes | The date in yyyy-mm-dd format to query to (inclusive) | |
unit | No | Time bucket size: 'hour' or 'day'. Default is 'day' | |
where | No | An expression to filter events by based on the grammar: <expression> ::= 'properties["' <property> '"]' | <expression> <binary op> <expression> | <unary op> <expression> | <math op> '(' <expression> ')' | <string literal> <binary op> ::= '+' | '-' | '*' | '/' | '%' | '==' | '!=' | '>' | '>=' | '<' | '<=' | 'in' | 'and' | 'or' | <unary op> ::= '-' | 'not' | |
workspace_id | No | The ID of the workspace if applicable |