Skip to Content

How to plot values that depend on the whole result set in a diagram?

Feb 17, 2017 at 03:08 PM


avatar image
Former Member


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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers