Hey Natalie Giggy,
I may spend more time playing with the packaged workbook tomorrow but a quick thought, would you be able to add the "correct answer" calculated field to "label" on the marks card and measure by "count?" In theory wouldn't this give you the number of correct responses?
Maybe I'm way off. I'm more of a Server guy so I'm still learning my way around Desktop.
If I understand correctly, I think the method you describe would work fine for each individual question on a separate viz. I don't think it will work to get the % who answered correctly multiple questions all in one viz, would it?
Thanks so much for your help!
1 of 1 people found this helpful
Natalie, it doesn't look like you're reshaping your data -- a critical step in working with survey data, that will allow you to accomplish what you want. If you can send me your raw data in Excel I can show you how it would work. email@example.com.