Hello,
I'm currently trying to calculate and plot the average and the standard deviation of a measure. In order to do this, I created two variables with the following content:
= Average([XXX]) In ([XXX])
= StdDev([XXX]) In ([XXX])
where [XXX] stands for the name of the measure. If I drag the variables to a table, everything works fine. But if I try to create a chart where the category axis is a dimension exactly containing the values of [XXX], the values are calculated for single rows only. In other words: The mean of each value is the value itself and the standard deviation (naturally) is zero.
How can I tell the chart that these values should depend on the whole result set?
Many thanks in advance!