Forum Discussion
How do I create a chart with an or filter
Hi, I have this table Labels Blue Red White Green Blue;Red Y Y Red;White Y Y Green Y I want to have a pie chart that will say the percentage ...
Hi, eventually I want to have the relative amount per color (sum if per color) that has Y in this pie (count if)
| Amount/color | Blue | Red | Green |
| 5 | Y | Y | |
| 20 | Y | ||
| 6 | Y | ||
| sum 31 | |||
| Count if | 1 | 2 | 1 |
| sum if blue | 5 | 0 | 0 |
| sum if red | 0 | 25 | 0 |
| sum if green | 0 | 0 | 6 |
Hi,
In my actual charts I have something like 5 categories (which are colors here) and 50 rows. The amount is a number that represents time, so my goal is to know how much time we invested per category aka color
Thanks,
Moran