Seperating multiple choices from a graph

1

we’re keeping track of books in our book club, and sometimes more than host reads the same book. I used select list and allowed it to add more than one person, but this is how it looks in a pie chart. Is there a way to fix it?

image
image856×494 19.7 KB

2

Hi Asma,

You’ll want to make your chart from a different table. To resolve this please do the following:

  1. Create a new table that lists one person’s name on each row. Let’s call this your “Members” table. Call the first column in the table “Member”.

  2. Add a second column to your Members table. Let’s call this column “Books”. In this second column, you’ll need to link your 2 tables. The precise formula will depend on what you’ve named the column in your original table, but here’s an example formula to give you an idea.
    Books.Filter(Members.ContainsText(thisRow.Members))

  3. Add a 3rd column to the Members table. Let’s call this column “Number of Books”. Add this formula to this column. Books.Count()
    This column obviously counts the number of books each person has read.

Now with your new Members table you should be able to visualize the number of books each person has read.

Hope that helps! :slightly_smiling_face:

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.