chart: how to force min & max values on axis to avoid extreme values?

[Aspire]

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

[Lynn]

Can you filter them out of the query?

[Aspire]

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

[BigChris]

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?

[Lynn]

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.

[navissar]

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.

[Aspire]

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