With some help from you guys, I was able to make a user onboarding survey using the CHOICE form! Users take the survey to choose preferences in many different categories (coffee v tea v cocoa) etc.
I have a google sheet tab with the options and another sheet that records the user’s choices.
I tried to render a chart that shows ALL of the choices in a pie, but it is only showing the data from ONE of the many choice categories. I watched the charts tutorial and it talks about creating a multiple relation in a new tab but I have tried doing that and don’t understand how to match the multiple choices into the form for each user.
It’s very hard to explain it all in a message so I’ve picked up from here in this quick video.
As always, I’m sure I’m missing something simple and appreciate any help!