How to cluster list items once in pie charts

Hey all!

I cannot for the life of me figure out how to do something I think is probably quite simple. I’ve looked online, the forums, gpt no luck.

So the scenario -
I have a table, that has a dropdown list column with multiple selections enabled.
There is also a capacity column.

An example of the rows would be:
Row 1: List item 1 - 10 hours
Row 2: List item 2 - 20 hours
Row 3: List item 1, List item 2 - 20 hours

The way the pie chart shows this data currently is:
List item 1 - 10 hours
List item 2 - 20 hours
List item 1, List item 2 - 20 hours

Is there a way I can make the pie chart instead show this as:
List item 1 - 30 hours
List item 2 - 40 hours

Thank-you in advance for any help. Even if it’s to say it’s no possible. :slight_smile:

Hi @Brendan ,

Thanks for writing in. Do you have a sample do you can share here/embed so we can look at what you are trying to do?

At first glance it sounds like what you want to do is create a new column with a select list of the two options you are looking for. Then in add a switchif() formula based on Row 1,2, or 3. This will compile the data into the two options you have set in that row, and they you can base the chart on that data.

Hope that helps!


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