Query & View Gotchas

Read this before writing views or queries. These patterns cause most query errors.

Charts: ONE Aggregate Per View

Charts render only the first aggregate. Use exactly one aggregate per # bar_chart / # line_chart view.

// WRONG: revenue is ignored
# bar_chart
view: x is { group_by: status, aggregate: order_count, revenue }
// RIGHT: single aggregate
# bar_chart
view: x is { group_by: status, aggregate: revenue }

For multiple metrics: nest separate chart views in a # dashboard, or use y=['revenue','cost'] for multi-measure series.