Top 3 Averages

[#1]

Hey could someone help me with an issue i have got,

I have 7 feilds :

     ResponseID,

     Region,

     LotusNotes,

     SAP R/3,

     MSOffice,

     VPN,

     VideoConferening,

Where LotusNotes,SAP R/3,MSOffice,VPN and VideoConferencing are applications which are rated from 1-10.

ResponseID is an ID given to each individual that has rated an application.

Region relates to where the individual is from.

I need the applications to be sorted by top 3 averages , but then if the filter Region was selected it would change the averages according to that Region.

[CELAMBARASAN]

Hi,

     What do you mean top 3 averages here?

Celambarasan

[#3]

As in i need the averages for each application , and then for them to be sorted with only the highest three averages showing

[CELAMBARASAN]

Hi,

     You mean in each region for each application?or averages across application for each response id?

celambarasan

[#5]

Yeah so if a region was selected the averages would change on each application according to the region they are in

[Clever_Anjos · Accepted solution]

0) Crosstable your data

1) Create a Simple Table Chart with your dim/expressions
2) Sort it by your expression (Sort Tab)
3) Show only 3 rows (Presentation Tab)

[#7]

Thank you this really helps - also is there a way to format this such that any application that has less than 5 responses is ignored?

[Clever_Anjos]

Yes,
use

if(count(ResponseID) < 5,0,avg(Dados))

as your expression a "supress zeros" (Presentation Tab)

[#9]

thank you works like a dream