9 Replies Latest reply: Jun 6, 2013 4:26 PM by Christian Farley RSS

    Set analysis on last 12 months, based on selected quarter

      Good day,

       

      I think I am near to solving this but I have hit a wall. The below expression returns monthly counts for the last twelve months based on a selected quarter, but the counts are way higher than what they should be (hundreds of Ks instead of a few dozens).

       

      =Count({1<[CaseDates.Calendar Date] = {">=$(=MonthStart(Max([CaseDates.Calendar Date]), -12))<=$(=MonthEnd(Max([CaseDates.Calendar Date])))"},[CaseDates.Month Name]=,[CaseDates.Calendar Year]=>} DISTINCT [Case Number])

       

      I am sure it is something silly but I have had no luck solving it.

       

      Thanks.