ChartDataExtras

havingstring

HAVING clause to be added to aggregate queries using AND operator.

instant_time_comparison_rangestringnullable

This is only set using the new time comparison controls that is made available in some plugins behind the experimental feature flag.

relative_endstring

End time for relative time deltas. Default: config["DEFAULT_RELATIVE_START_TIME"]

Possible values: [today, now]

relative_startstring

Start time for relative time deltas. Default: config["DEFAULT_RELATIVE_START_TIME"]

Possible values: [today, now]

time_grain_sqlastringnullable

To what level of granularity should the temporal column be aggregated. Supports ISO 8601 durations.

Possible values: [PT1S, PT5S, PT30S, PT1M, PT5M, PT10M, PT15M, PT30M, PT1H, PT6H, P1D, P1W, P1M, P3M, P1Y, 1969-12-28T00:00:00Z/P1W, 1969-12-29T00:00:00Z/P1W, P1W/1970-01-03T00:00:00Z, P1W/1970-01-04T00:00:00Z]

Example: P1D

wherestring

WHERE clause to be added to queries using AND operator.

ChartDataExtras

{
  "having": "string",
  "instant_time_comparison_range": "string",
  "relative_end": "today",
  "relative_start": "today",
  "time_grain_sqla": "P1D",
  "where": "string"
}