4 Replies Latest reply on Aug 3, 2012 6:24 AM by Peter Hopwood

# Plotting Top 10, Bottom 10 and Total results simultaneously

I'm currently working with a set of data where I have Profit (measure) and the dimensions of Region and Division.

My ideal would be to plot a graph which shows overall average total performance, the average performance of the top 10 performers and the average performance of the Bottom 10 performers.

Can anyone suggest how to go about scripting this, as the Set 'top 10' function, is great at separating the top 10, but then leaves me unable to plot this simultaneously against the average for the rest of the population.

Many thanks for all your help!

• ###### 1. Re: Plotting Top 10, Bottom 10 and Total results simultaneously

Hi Mike,

After sorting the view so that it is in the correct order, create a calculated field similar to the following:

index()<=10 or last()<=10

Then, place this on the filter shelf and select True. Only the top and bottom performers will appear. Hope this helps!

-Tracy

• ###### 2. Re: Plotting Top 10, Bottom 10 and Total results simultaneously

Tracy,

Thanks for your response, unfortunately I'm not sure it quite solves my problem.

I'm trying to simultaneously plot the aggregate of Top 10, Bottom 10 and Total Population.

Your approach would, I think, plot 20 lines (10 Top ones and 10 Bottom ones) seperately.

For example, with assuming a Top 1 and Bottom 1 variant, with 5 members of a group being

A: 3

B: 5

C: 10

D: 1

E: 2

Assuming I was plotting Total values, I would want to plot Top 2 (10+5 = 15), Bottom 2 (1+ 2 = 3) and Population (sum = 21) at the same time.

Alternatively, with averages, I would be plotting Top 2 (7.5), Bottom 2 (1.5) and Population Avg (4.2)

In both cases I would want to plot a set of 3 points for each month over a 4 year period.

My question is therefore how to create a new plottable set with 3 values, being the Top x, Bottom x and Population total.

A similar way to look at this would be 'how would I plot the Median, Upper and Lower quartiles of a dataset on the same graph'.

Many thanks

Mike

• ###### 3. Re: Plotting Top 10, Bottom 10 and Total results simultaneously

Thanks Tracy, That worked for me :-)

• ###### 4. Re: Plotting Top 10, Bottom 10 and Total results simultaneously

Mike,

If you are after the : '...Median, Upper and Lower quartiles of a dataset on the same graph'. could you use reference lines on a chart to achieve this - as you have the options of medians and quartiles with reference lines?

Peter