Add up scores across questions then breakout by each answers score

Question

I have an intranet renaming contest where the first round of votes is narrowing down to the top 10 from 48 submissions.I’m trying to figure out a way to best display this within a dashboard. I have the two widgets below but since I’m using a measure group, the values and not the labels are coming in. Both of these graphs don’t really help the decision makers easily figure out which are the top 10 amongst all the individuals who voted. I chose to use 10 different multiple choice questions instead of the rank order question because they only have to rank 10 out of 48 and the rank question didn’t seem to be the best user experience for that. I also have it so that each question only carries forward the Unselected options so previously selected choices are removed from the remaining choices.I thought maybe I could attach a score to each question (First to Tenth choices = 1-10 points respectively). Lowest score would rank the highest. However, I’m not able to figure out how to tie that in to have it be a summary of the scores per each name from that list of 48 that have been voted for.I want to be able to show that Name1 scored 11 points (it was voted as first choice and tenth choices), Name2 score 15 points (it was voted as first, fifth and tenth choices), etc. Then be able to sort that from lowest to highest. Where the lowest 10 move onto the next round.

Chee Heng_SZ · Accepted Answer

Hi ​@courtrc,Perhaps you can try to use scoring and create a category for each choice that set increasing/decreasing score value forthat specific choice across your ten questions.If assuming you give 1 pointfor Top1 and 10 points for Top10 (Increasing),you can have the first question with all choices as 1point, second question with all choices as 2points, …, with the tenth question with all choices as 10 points.Then, if choice 1 got selected as Top1, Top5 and Top10, the Choice1 category will give a score of 16.Similarly, choice 2 with Top2, Top3 and Top4, Choice2 category will give a score of 9.Instead of the ten questions as a measure group, use the 48 score categories and in your widget, take the Bottom10 score categories.If assuming you give 10 points for Top1 and 1 point for Top10 (Decreasing),you can have the first question with all choices as 10 points, second question with all choices as 9 points, …, with the tenth question with all choices as 1 point.Then, if choice 1 got selected as Top1, Top5 and Top10, the Choice1 category will give a score of 17.Similarly, choice 2 with Top2, Top3 and Top4, Choice2 category will give a score of 24.Instead of the ten questions as a measure group, use the 48 score categories and in your widget, take the Top 10 score categories.Scoring sample (using decreasing score)Measure group sampleWidget sample (using 15 test responses as sample)Hope this helps.

courtrc · Answer

​@Chee Heng_SZthank you so much! Ive only used scoring once before and it was for a much simpler scenario. I’d done one category and given each option a score, but was stuck on the piece of how to break them out. Thanks for such athorough explanation and screenshots! Appreciate your time helping me with this!

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded