Skip to main content
← All schemas

AggregateQuery

object

Ask PropZolo query: an entity, a filter (shared filter DSL), a calendar range, measures, one group-by, sort, top-N.

entityrequired
string
filterrequired
FilterNode or null

PropZolo filter: { all: [...] } | { any: [...] } | { not: … } | { field, op, value }

rangerequired
AggregateDateRange or null

A preset period or calendar days (inclusive), company time zone.

group_byrequired
AggregateGroupBy or null
limitrequired
integer or null
Example
{
  "entity": "string",
  "filter": null,
  "range": {
    "field": "string",
    "preset": "today",
    "from": "string",
    "to": "string"
  },
  "measures": [
    {
      "fn": "count",
      "field": "string"
    }
  ],
  "group_by": {
    "field": "string",
    "bucket": "day"
  },
  "sort": {
    "by": "value",
    "field": "string",
    "dir": "asc"
  },
  "limit": 1
}