3 Replies Latest reply on Jun 25, 2019 2:36 PM by Matthew Burke

    Help with Forecast/Combine multiple Date Axis for Running Sum

    Matthew Burke

      Good afternoon everyone!

       

      I'm looking to combine my current running_sum by day with a future running_sum by day to give a total for the year.

       

      Essentially, we have 3 different test types for our assets.  Based on the last test date I can do a running sum of what has been tested this year.  I have a calculated field that tells me what the next test date is based on the test type.

       

      What I'm trying to show is the running sum of current tests this year, then additionally add the running sum of future tests as a sort of prediction.  Here's what I have so far:

       

      Current:

       

      Expected (sorry for my ms paint skills):