Check how a chart is calculated

Choose “How it’s calculated” in a chart’s ⋯ menu, or the link at the top of the Expand dialog. It lists, in order, the dataset the chart reads, the filters that keep rows, what it groups by, how each number is calculated, the order and the row limit.

Every step names the source column as stored, with its machine name and type (for example revenue · float). If the assistant picked the wrong column, or a column was read as the wrong type, you will see it here. Fix it with “Change visualisation”, or by asking the assistant again with the column you meant.

Some measures, such as unique users or rates, can’t be added up. When a chart asked for a sum of one, the panel shows the average it uses instead and explains why. “Show SQL” reveals the query and lets you copy it.