0 Replies Latest reply: Feb 9, 2015 11:08 AM by Sasi Kumar RSS

    Rolling 12 months backwards

    Sasi Kumar

      Hello,

       

      In my expression, i am adding this code,

       

      Count({$<[Cause Code]={'Access Issue'},InciMonth = {">=$(=Month(MonthStart(Max(Approved))-365))<=$(=Month(MonthEnd(Max(Approved))-1))"},InciYear=,InciMonth=>}[Task])

       

      Here i am counting the Task with the Cause Code ='Access Issue'.

       

      Approved is the Date column . InciYear & InciMonth is the Year & Month Respectively.

       

      The values i am getting correctly, but the x-axis is not changing based on my month selection. Can you please help me out.

       

      Thanks,

       

      Sasikumar.R