mixpanel

by dragonkhoi
Verified

query_segmentation_sum

Sum a numeric expression for events over time

Input Schema

NameRequiredDescriptionDefault
eventYesThe event that you wish to get data for (single event name, not an array)
from_dateYesThe date in yyyy-mm-dd format to begin querying from (inclusive)
onYesThe expression to sum per unit time (should result in a numeric value)
project_idNoThe Mixpanel project ID
to_dateYesThe date in yyyy-mm-dd format to query to (inclusive)
unitNoTime bucket size: 'hour' or 'day'. Default is 'day'
whereNoAn expression to filter events by
workspace_idNoThe ID of the workspace if applicable

Input Schema (JSON Schema)

{ "$schema": "http://json-schema.org/draft-07/schema#", "additionalProperties": false, "properties": { "event": { "description": "The event that you wish to get data for (single event name, not an array)", "type": "string" }, "from_date": { "description": "The date in yyyy-mm-dd format to begin querying from (inclusive)", "type": "string" }, "on": { "description": "The expression to sum per unit time (should result in a numeric value)", "type": "string" }, "project_id": { "description": "The Mixpanel project ID", "type": "string" }, "to_date": { "description": "The date in yyyy-mm-dd format to query to (inclusive)", "type": "string" }, "unit": { "description": "Time bucket size: 'hour' or 'day'. Default is 'day'", "enum": [ "hour", "day" ], "type": "string" }, "where": { "description": "An expression to filter events by", "type": "string" }, "workspace_id": { "description": "The ID of the workspace if applicable", "type": "string" } }, "required": [ "event", "from_date", "to_date", "on" ], "type": "object" }