4 Replies Latest reply: Jun 4, 2015 10:16 PM by Xianqun Luan RSS

    Get total over Calculated dimension

      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