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"
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)
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)
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.
