Good day -
In our reporting, we are using a Master Dimension to filter a select group of records based on the value in the "Workflow" field. The Master Dimension only allows those values that being with "MM*". I have a need to have a column showing the filtered value totals, as well as one that shows the total without the filters affecting it, but while still including the report dimensions.
If I just look at "Workflow", the following work fine: =count(distinct {$<Workflow=, $(vTimePeriod)={1}>} feedback_id)
However, using "Workflow" directly as a filter is somewhat problematic due to the number of values to be selected.
TOTAL does not work as it overrides both the Dimensions and Filters.
I would like to use the values from the Master Dimension filter (titled "MM_Workflow") but it appears I am unable to bring this into the Set Expression. Can anyone provide suggestions on how I might get past this?
Thanks,
Mitchell