Add Calculated Dimension...

[danialier]

Hello,

I have a Grid Chart displaying countries (x axis) and I want to show in the y axis the revenues.

For that reason I tried to add a new dimension by clicking the "Add Calculated Dimension..." in the 'Dimensions" tab. Then, in the edit expression I entered "=sum(Revenues)".

However in the Grid Chart an error message says"//Error in calculated dimension"

I don't know what I'm doing wrong...

Please help.

BR,

dani

[Gysbert_Wassenaar · Accepted solution]

sum(revenues) will only return one value, not a list of values. You'll have to use the aggr function to aggregate the sum over one or more dimensions. Something like =agg(sum(revenues),CountryName). Or perhaps you want to create buckets of revenue. In that case you can use the Class function: =class(sum(revenues),1000)

[richard_chilvers]

Perhaps you don't need a grid chart ? If you simply want to show total revenue for each country, try starting with a bar chart. A grid chart usually has 2 dimensions and an expression.