I am currently working on creating a pie chart. To simplify things the pie chart has 4 parts. Lets call them 1,2,3,4. 1 and 2 are from category A. and 3,4 are from Category B. I want to filter out category A so that the pie chart will only show the percentages of 3,4 rather than all 4. Essentially its like saying in a table show me all rows where Column 1 = A and not rows where Column 1 = B. But I want to do this in graph as the sheet loads and not have a user have to click on the tab to filter on their own.
The expression I am using now is as follows: Count(IF (Name = 'A',Field,0))
With this I am hoping to only have the graph do a count of the rows where the data matches what I want and for the data I don't want have it count as 0 so it wont show up. This does not seem to make any difference when it updates.