SQX009 — Nested aggregation

Severity: error — blocks saving until fixed.

What happened

An aggregation directly inside another aggregation (Sum(Avg(…))). Aggregation arguments are columns.

How to fix it

To re-aggregate per-group values, compute the inner grain with Fixed and set the outer aggregation in the chart’s field well.