I'm using a chart with a single dimension and a single expression which counts the number of orders that are filtered by the dimension. Instead of showing the actual count though I just want to show a percentage of total orders. How can I include this in my expression? Right now I'm using the expression:
count(distinct [order ID])
I've done something similar and got help on this forum for a case where I had two dimensions, and I wanted to get the percentage of orders in the second dimension with respect to the first dimension, so I used:
count(distinct [Order ID])/count(distinct total <[Advice Status]> [Order ID])
In this case the order ID's were filtered first by advice status, then by rule. So the numerator was a count of the orders for that rule for that advice status, then divided by the total number of orders for that advice status to get a percentage of a rule for a specific advice status.
What type of qualifier would I need to count the total order ID's after the filtering has been done?
