Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
Hi,
What do you mean top 3 averages here?
Celambarasan
As in i need the averages for each application , and then for them to be sorted with only the highest three averages showing
Hi,
You mean in each region for each application?or averages across application for each response id?
celambarasan
Yeah so if a region was selected the averages would change on each application according to the region they are in
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)
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?
Yes,
use
if(count(ResponseID) < 5,0,avg(Dados))
as your expression a "supress zeros" (Presentation Tab)
thank you works like a dream