Hi,
How can I exclude extreme values from the axis in a chart? When putting min & max configuration extreme values are still taken into account in my chart..?
Thanks
Can you filter them out of the query?
Lynn,
Yes that's an option, but I would prefer a more dynamic solution. Because maybe tomorrow the extreme value will be another member which was not excluded in the query.. do you understand my point?
Thanks
I don't know if this will help the discussion, but how would you identify the extremes? Are you basing it on standard deviations or similar?
I assumed the extremes were known based on the original post indicating a min/max setting on the axis. Anything dynamic is going to require some understanding of what constitutes elements to be excluded, as Chris has indicated.
It's a question of maths. The logic is to identify a baseline and filter out values which are excessively high or low.
So, you can, for instance, identify the mean and SD and not show anything above/below two/three SDs.
Or you could go down the more brute force route of not showing anything bigger/smaller than X times the mean/median.
All these calculations can and should be done in the query.
Thanks all for reactions!
Indeed the extreme values are defined as variance% vs Baseline.
It's a good idea to filter out extremes as +- 100% variation for ex--> thanks for the insight!
KR