8 Replies Latest reply: Nov 8, 2016 3:51 PM by Nicole Smith RSS

    Help with vairable and time dimension

    Azmina Virani

      I am using this formula which give me current month at all time:

       

      ((Sum(aggr(count({<Month={'$(vMaxMonth)'},MonthYear=>}distinct USER_ID),MonthYear,Application_Version,[Application]))) / Count({<Month={'$(vMaxMonth)'}>} distinct MonthYear))

       

       

       

      ((Sum(aggr(count({<Month={'$(vPriorMonth)'},MonthYear=>}distinct USER_ID),MonthYear,Application_Version,[Application]))) / Count({<Month={'$(vPriorMonth)'}>} distinct MonthYear))