3 Replies Latest reply: Jan 31, 2018 1:22 AM by Kaushik Solanki RSS

    How to display the average total count for these 12 months?

    ahmad albab

      My detail as below:

       

      Dimension:

      =[Date Created.autoCalendar.YearMonth]

       

      Measure:

      =Count({$ <Temp={'Task_17'}>*$<[Date Created.autoCalendar.YearMonth]={">=$(=AddMonths(MonthStart(Today()-20),-11))"}> } [SR No])

       

       

      Subtitle:

      =Count({$ <Temp={'Task_17'}>*$<[Date Created.autoCalendar.YearMonth]={">=$(=AddMonths(MonthStart(Today()-20),-11))"}> } [SR No])

       

      *My subtitle show 3483. But what i want is 496/12=41.33. Please advise.

       

      qi.PNG