I have a form that’s asking what times people are available for a meeting. It’s a multi select. The Chart should only show the 3 options and the count of how many times those options were selected. But it’s creating extra bars for the times people selected multiple times. Can anyone help me get this to display right? Hoping there’s an easy formula to fix this.
1 Like
Hello @Rebekah_Harris ,
The way Coda looks at your Best Time entries, is such that an entry with two or three selected items is different from a single selection. You can see in your chart a different bar for any M
Monday combination (therefore three vertical bars for Monday).
There are different ways of solving this - my choice was to make a table with the best time options, make the best time column a relational column and make a chart of the new table (best time table).
Checkout the reworked doc (it is a copy of your doc):
3 Likes
You are a gem! Thank you so much!
2 Likes
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.