3 Replies Latest reply on Jan 5, 2017 6:33 AM by Simon Runc

    Missing Months and Rolling Sum

    michelle.smith.2

      I'm trying to show a graph where each month represent the current and last 12 months, and I want to show this over a 12 month period.  I have a lookup filter to correctly filter the view without filtering the data; however, I'm having some issue where I'm not getting the correct values where a company does not have data for every month.  So, in my attached example, The sort field is the value I want to show for the month of November, and that is working correctly for the company All.  However, the company X is only showing the last 12 months for its last data point, which is Sept. 2016.  The sum of amount from 11/1/15 - 10/31/15 (the most recent 12 months) should be $36,819.  Is there a way to extend the line for another two months and have the value calculated correctly?

       

      Thanks!