Hello all,
I want to answer the question: "What percentage of Accounts with DimensionA also had DimensionB?"
I'm trying to create a table chart that looks like this:
DimensionA
DimensionB
Expression1 = Count(Distinct ACCOUNTNUMBER)
Expression2 = [count distinct accountnumber for data that matches DimensionA but ignores DimensionB]
Expression3 = Expression2 / Expression1.
As you can see, I'm stuck on Expression2.
I know that I can use Set Expressions to ignore SELECTIONS like so:
=Count(distinct {$<DimensionB=>}AccountNumber)
...but this doesn't carry over to chart dimensions. Any suggestions on how to model a set expression (or something else) to get what I want?
