4 Replies Latest reply: Sep 13, 2017 7:29 AM by kushal chawda RSS

    Date Formats

    bhavani b

      Hi Everyone,

       

      I am trying to calculate the Max(Month) along with last 6months trend with the below expression

       

      =Sum({<Area= {'America'},MonthYear={">=$(=date(addmonths(Max(MonthYear),-6),'MMM-YY')) <=$(=date(Max(MonthYear),'MMM-YY'))"}>}Incidents)

       

      Here I ma getting the last 6motnhs but not getting the max(month) in the bar chart. I am missed anything.Please help me.

      For example in the below getting Mar to Aug but I need the max(Month) i.e. sep-17 also.

      Thanks.