I have the same ranking question in different surveys is it possible to consolidate them to get a summary with the weighted average of all surveys and get a table similar to what you explain in that post?
Answered
How to consolidate ranking results from multiple surveys with the same question
Best answer by john.desborough
the easiest way to do this would be to Connect each survey to the same Google Sheet and get all the responses pushed to the Sheet. Each survey would show up on a separate tab in the google sheet. you could then create an additional tab and collect/aggregate across the surveys based on the question (you would need to ensure that the unique identifier/key for each question was the same or do a lookup on the text of the question (assuming they were all identically worded)
that would allow you to do the analysis you are seeking… at least as far as i can tell
des
+6- Certified Partner & Champion
- 5330 replies
- Answer
the easiest way to do this would be to Connect each survey to the same Google Sheet and get all the responses pushed to the Sheet. Each survey would show up on a separate tab in the google sheet. you could then create an additional tab and collect/aggregate across the surveys based on the question (you would need to ensure that the unique identifier/key for each question was the same or do a lookup on the text of the question (assuming they were all identically worded)
that would allow you to do the analysis you are seeking… at least as far as i can tell
des
If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
1 person likes this
Thank you John,
That was helpful.
Once I have a consolidated Tab
How can I then summary that tells me what is the average ranking position of each option?
I’m trying to have the summary below (generated by typeform) for the consolidated tab you where suggesting.
1 person likes this
+6- Certified Partner & Champion
- 5330 replies
that would be where you have to do the analysis work in determining the averages and ranking them in the order that you choose in the Google Sheet.
If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.