This content has been marked as final. Show 4 replies
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.