Multiple column values into single column (columns become x axis)

[Matthew_Viner]

Hi Gliders,

I’m using a form to capture diagnostic info, it’s binary so “yes” = “1”. The form will show “yes” to user and input a 1 on the sheet. There are 100 questions and 10 categories. I use a Math column to sum the categories. So I have 10 columns, one for each category, with the total score in each. This is all fine.

I want to show a chart, with the different categories on the x axis and the values being the score for each category. This would be user-specific, meaning that the signed in user would see their own results only.

Is there a way to do this? I feel like maybe a query is possible but still not deft at using it.

Thanks in advance,
Matt

[Darren_Murphy]

Any chance you can show a screen shot of how that looks in the Data Editor?
Just having a little trouble visualising it.

[Matthew_Viner]

Thanks for the reply Darren, happy to see you here! Few pics incoming.

Perhaps there is a totally different way to acheive this, I can’t work it out. I could have a “Yes” response give the category rather than simply “1” and then count the occasion of the category, but I still have multipe categories (therefore columns) to move into the chart format…

Have named images for reference

Thanks,
Matt

[Matthew_Viner]

Rows 1-4 are before I set the “yes” form entry to “1”, these can be ignored

[Matthew_Viner]

This worked for me https://www.youtube.com/watch?v=t-sh_Q3WbQc&ab_channel=RobertPetitto

[Darren_Murphy]

Yes, that’s what I was going to suggest. Just wanted to make sure I correctly understood how your data was laid out.