Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to find the average of overall experience values every month. The trick is that the average is done by reoving the top5 and bottom 5 values. Eg, if we have 100 values we need to average from 6 to 95. Any ideas on how to do it? Either in scripting or chart expression is appreciated.Thanks in Advance.
hei
attach is an example
the text box contains the formula that you asked
See the Qikview Cookbook example "Removing outlier values from a chart dimension." for some options.
-Rob