I am trying to create a simple percentage measure and display in a table visualization. The measure is calculated by dividing two distinct counts - the denominator is a distinct count of clients within a time period, and the numerator is a distinct count of clients within the period who satisfy a condition. In other words, the numerator is just the denominator with a filter applied.
I can't figure out how to do this in Dundas, because the table visualization only allows 1 metric set - I am able to create the denominator simply by using a Distinct Count aggregator on my desired dimension. How can I create the numerator - by applying a filter to the denominator - while maintaining the distinct count?
I need this calculation to be done within the metric set (not in the data cube) because I want the distinct count to change based on the selected period within a time dimension.