Hello Tableau Forum,
I'm stuck trying to write a simple table calculation
Below is a mock data set. What I'm trying to find is the percentage of apples that are red, which should equal 75% (3/4)
I wrote the following table calculation but cannot figure out why it does not work. Can someone take a look?
IF ATTR([Fruit])="APPLES" AND ATTR([TYPE])="RED" THEN COUNT(TYPE]) / TOTAL(COUNT([TYPE)])) END
Thanks for the assistance!