Hello, sorry if this has been asked elsewhere but I can’t find it. I’m also totally new to databases and coda.
I’ve made a very simple table and form. Currently all it collects is a date and then the user selects some criteria from a multi-select list.
I’d like the pie chart to show how frequently users select each option on the list. Currently the pie chart combines all the list options together into one “answer.” I didn’t select for it to aggregate, so I’m confused why if a user selects A, B, D, and Z instead of counting those 4 values separately, it counts them as one answer.
I’ve gone into the chart options but I don’t see a way to do it. Do I need to use formulas to count the frequency of each value?
Thanks for responding!
Unfortunately that’s not what I was trying to achieve. I was trying to get the pie chart to show me how many times did someone select each one of the multiselect options over all entries.
If I were doing it manually in a spreadsheet, I would take the data from the form and organize it like this to achieve the pie chart below:
I’m guessing I have to use formulas to reorganize the data the way it is shown in the screenshot and then use the reorganized data to make the chart? I was hoping to do it directly from the form data.
