ReportSpec

object

A report: entity, filter (shared DSL), range, up to 4 measures (count, sum/avg/min/max of a field, count_if / rate of an outcome, a catalogue ratio), a group-by and an optional split, sort, top-N and the chart.

vrequired: 1
entityrequired: "leads" | "deals" | "visits" | "calls" | "tasks" | "messages" | …
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.
measuresrequired: array of object
measures[].fnrequired: "count" | "sum" | "avg" | "min" | "max" | "count_if" | …
measures[].fieldrequired: string or null
group_byrequired: AggregateGroupBy or null
split_byrequired: AggregateGroupBy or null
A second dimension: one series per value (pivot).
sortrequired: object or null
sort.byrequired: "value" | "key"
sort.dirrequired: "asc" | "desc"
limitrequired: integer or null
visualrequired: "table" | "bar" | "line" | "kpi"

Example

{
  "v": 1,
  "entity": "leads",
  "filter": null,
  "range": {
    "field": "string",
    "preset": "today",
    "from": "string",
    "to": "string"
  },
  "measures": [
    {
      "fn": "count",
      "field": "string"
    }
  ],
  "group_by": {
    "field": "string",
    "bucket": "day"
  },
  "split_by": {
    "field": "string",
    "bucket": "day"
  },
  "sort": {
    "by": "value",
    "dir": "asc"
  },
  "limit": 1,
  "visual": "table"
}