I am presenting survey results and am having trouble displaying the representation I have in mind. In the survey, members of different teams answered questions which were grouped by category. Right now I have a row for each category of question that shows each team's average score for that category. Instead of showing the full spread of teams, I would like to simplify the visualization by just showing the number of teams who's average is between 1 and 2, 2 and 3, 3 and 4, 4 and 5. I tried creating a calculated field with some if statements to group the averages, but the field I made didn't give me the results I wanted.
I'd appreciate any suggestions or solutions. Thanks
Morning Robert,
Find my updated approach as reference below and stored in attached workbook version 10.2 located in the original thread.
1. Team avg: {fixed [Team]:avg([Value])}
2. Question avg: {fixed [Team],[Question]:avg([Value])}
3. Category avg: {fixed [Team],[Category]:avg([Value])}
4. Team avg (bin)
5. Question avg (bin)
6. Category avg (bin)
Regards,
Norbert
