query_segmentation_sum

Calculate the total sum of a numeric expression for specific events within a defined time range. Use this tool to analyze event data by filtering, time-bucketing, and summarizing metrics in Mixpanel.

Instructions

Sum a numeric expression for events over time

Input Schema

Name	Required	Description
`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
`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
`workspace_id`	No	The 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"
}

mixpanel

query_segmentation_sum

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from mixpanel

Related Tools