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.