Skip to Content

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


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!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers