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.