14 Replies Latest reply: May 30, 2018 10:16 AM by Sunny Talwar RSS

    Use Total Function With Average And Aggr

    Elie Issa

      Dear All,

       

      Please help me to find a solution for the below :

       

      I Need to get the average Ratio of last 26 weeks for each month and show it on a Line Chart Trend as shown in the below Screens.

       

      Instead of showing 26.97% I need to show 26.03 % for May 2018 (average 26 weeks)

      Also

      Instead of showing 26.11% I need to show 25.65 % for Apr 2018 (average 26 weeks)

      And the same for the other months.

       

      Capture 2 May.PNGcapture 1 Apr.PNG

       

       

      Expression :

      avg({<Month = , Year = , [Month Year] = , [Week Year] = >}

      aggr($(vNationalizationRatioLast26Weeks),Week , [Month Year],[Business Unit]))

       

       

      Regards.