Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a measure for counting distinct members..this seems to work
aggr(count(distinct member_key),source_provider_name)
However, if i wanted to add a where clause to it, how would it look...
I tired 'aggr(count(distinct member_key),source_provider_name) where[source_provider_name] = 'SPECIFIC PROVIDER NAME'
It did not seem to like it.
Thanks in advance...
try
aggr(count({<[source_provider_name]={'SPECIFIC PROVIDER NAME'}>}distinct member_key),source_provider_name)