Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I can't believe I can't figure this out.
I am making a simple bar chart, based on dimension 'ORDERSET'
The first expression is Count(DISTINCT VISITGUID)
And so the bar shows exactly what I'm looking for.
For my second Expression, I want the count of DISTINCT VISITGUIDS for ALL THE ORDERSETS (in other words, ignoring the dimension.
So, if there are 5 total Distinct VISITGUIDS, I want 5 to be the value of the expression for each of the ORDERSET dimension.
Why am I having so much trouble with this? Help!
Hi,
try set_analysis with the TOTAL operator - that should do what you want.
Best regards,
DataNibbler
I appreciate the suggestion DataNihhler.
I played with set analysis, but was getting lost in the weeds.
I ultimately tried this and it seems to work:
=Count(TOTAL {$<OrderSet=>} DISTINCT VISITGUID)
Well, that would work too. I think it's a bit more than you need - try without the set_expression and without the DISTINCT keyword maybe - but if it works, off you go ...