Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a category called 'Ranking' in my straight table. In this field are numbers 1-5 (I am creating a QV Report based on survey results, so each attendee is ranking 10 different presentations from a 1 to a 5) I want to create a table that counts how many 5's , 4's, 3's, 2,;s and 1's there are for each presentation. Do i need to create an if statement in expressions or is there something in the script i need to do? I feel like this is really simple, but I can't figure it out, would appreciate some help! Hopefully these tables make it more clear
THis is the table i have now which i pulled from excel:
Attendee | Company | Presentation Title | Speaker | Ranking | Comments |
---|---|---|---|---|---|
A | AA | sfasdfs | sdafsdf | 2 | |
B | BB | safdsf | sadfads | 4 | |
C | CC | safds | asfdsa | 5 | |
D | DD | asdfsaf | sfads | 2 | |
E | EE | safads | sadfs | 1 | |
F | FF | asdfsadf | dsfasd | 5 |
What i want is to display the survey results by each point (1-5) that people rank the presentations.
Presentation | 5: Excellent | 4 | 3 | 2 | 1: Poor | Average |
---|---|---|---|---|---|---|
Looks like a pivot table with dimensions Presentation and Ranking (or perhaps Ranking Description), and an expression like count(distinct Attendee). The problem with that is that your Average column would instead be just the total number of people at that presentation. So you actually need to modify the calculation depending on if you're one of the rankings or if you're the "Total" for the column. Hmmm, it's taking me longer to try to find an existing example on my hard disk than it would take to build you one. So see attached. Here's the expression:
if(secondarydimensionality(),num(count(distinct Attendee),'#,##0'),num(avg(Rank),'#,##0.0'))