I have a Pie chart on one of my dashboards and I'm trying to figure out how to properly set up the dimension and measure to the requirements given to me. Basically I need it to show the count of ACC_IDS that have a RESULT_ALPHA= positive within a test_ID range of 53001<= and >=53027 as the measure . for the dimension however is a little more complex and im unsure how to go about it but each acc_id have multiple TESt_id's that could have a result negative or positive. I need the dimension to show the number of test_ids with a positive. for example there would be 43 ACC_IDS with one result_id positive, there would be 20 ACC_IDS with two result_ids that are positive, there would be 12 ACC_IDS with three Result_ids that are positive etc... Each slice of the pie graph would be the number of result_ids that are positive per accession. how do i go about this?
