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

    Rolling 12 months backwards



      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.