Hi
I want to show only outliers in a stacked bar chart. I have events related to buses and days. I use buses and days as the dimension, sum(event) as the expression [Event is a flag set to 1 for each record].
What I try to achieve is a reduced graph that shows only total events of buses with a high number of events. What I try is to calculate an average of all bus events within a day and use an if condition to show the events total only fur buses exceeding e.g. twice the days average.
As I already have the buses and days in the dimension I can not figure out how to get the days average in an expression.
Thanks
Jürg