Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if I create a calculated dimension like below
if(charge<15000, 'Low charge', if(charge<50000, 'High charge', 'Med Charge')
and had 2nd dimension age_grp, which from load data
Now, I want to compute the % of age_grp within charge level like
count(distinct subject_id)/count(total <calculated charge level> distinct visit_key )
My question is how to add the calculated dimension in the count function.
Thanks
This seems to work:
Count(DISTINCT [subject id])/Count(DISTINCT TOTAL <charge> [subject id])
Will you be able to share a sample?
I create a simple example to show my question as below
This seems to work:
Count(DISTINCT [subject id])/Count(DISTINCT TOTAL <charge> [subject id])
brilliant!!!!!!!!!!!!!11