23 Replies Latest reply: Oct 26, 2016 12:31 PM by Eduardo Sommer RSS

    Rolling 13 Month View Not Working As Expected

    Perry Newman

      Hello:

       

      I had asked for assistance with this in an earlier thread and we thought we had it working, but it is not.  I have a stacked bar chart where I would like to have a 13 month rolling view of the data.  I'm using the following expression:

       

      =Sum({<Date={">=$(=MonthStart(Today(),-12))<=$(=MonthEnd(Today()))"}>}CHARGE_AMOUNT)

       

      When I first put this in place, it appeared to work as 201509 through 201609 was displayed.  However, I've now loaded 201610 data and instead of seeing just 201510 through 201610, I'm seeing 201509 through 201610.  I want 201509 to fall off.

       

      Any ideas?  As usual, any and all help will be appreciated.  Thanks in advance.