Skip to main content

AggSpec

Inline aggregation definition. agg is required; expr may be omitted only for count, and percentile must be between 0 and 1 when agg is percentile.

aggAgg (string)required

Possible values: [sum, avg, min, max, count, count_distinct, median, percentile]

expr object
anyOf
string
percentile object
anyOf
number
clauses object[]
  • Array [
    • columnColumn (string)required

    Semantic column definition. Capability flags control filtering, sorting, grouping, and catalog visibility; values is exhaustive, samples is illustrative, and dictionary-backed columns suppress both value lists from semantic catalog output.

    opOp (string)required
    valueValue
    granularity object
    anyOf
    string

    Possible values: [day, week, month, quarter, year]

  • ]
    • AggSpec
    {
      "agg": "sum",
      "expr": "string",
      "percentile": 0,
      "clauses": [
        {
          "column": "string",
          "op": "string",
          "granularity": "day"
        }
      ]
    }