So I am aggregating data based on 3 fields. Let's call them:
account_code, admin_name, test
These are all dimensions with account_code being the broadest, which has several admin_names underneath each, and each admin_name having several tests undernearth.
My measure, let's call it value is the measure being summed at this level. I also have another measure called test_value I'm bringing in as max. I then have a calculated field called value_check which says:
IF SUM([value]) > MAX([value_test]) THEN "Fail" ELSE "Pass" END
Which makes a failure simple pass/fail test.
Now, what I am trying to do is create a pie chart that just shows pass/fail at this specific aggregation level (i.e. 10 fail/90 pass). I am guessing I need to use FIXED or INCLUDE to basically recreate what I did in the view, but my trials have been unsuccessful. Am I barking up the right tree? Is there a way to do this easily?