Hi there! I am trying to make a pie chart based off some info from a very simple table that I made. I am trying to have the pie chart give me the frequency each item from a select list is used. Currently I can select multiple items from that list per entry so the pie chart is grouping them altogether that way versus each selection individually. I’m sure it’s a simple fix, but I can’t seem to figure it out! Anyone have any pointers? Thank you!
Hi Jessella,
I think the only way is to turn your select list into a table, create an extra column that counts the items in the original table and create the pie chart based on the new table.
Here you have a litle example
Let me know if this helped!
Pablo
2 Likes
For some reason, when I convert the select list column into a table, it automatically shows it as text (first screenshot). If I set it to be a “relation” it changes it to something I don’t want haha (second screenshot). The third screenshot is my original table- I’m trying to make the pie chart of items from the “Type of Exercise” column for reference!
Hello @Jessella_Snyders
It seems that you are trying to change the column type to linked relation in the “Types of Exercise” table, which you should not do. When you convert a select list into a table, Coda just takes all your options (which are all text) and creates a column with each option as a row.
When you convert to a table, you will see that the “Type of Exercise” column on “Team Notes” changes to a relation column, saying now that the content is a reference to the “Type of Exercise” table.
Now, you just need to add a column on the created table to count how many rows in the “Team Notes” have the specific type in it, which represents the example shown by Pablo.
I hope this helps to clarify a little
Cheers,
Arnhold
1 Like
I FIGURED IT OUT!! Small victory on a Friday! 
Thank you both!!
3 Likes