0 Replies Latest reply on Jan 9, 2014 3:21 PM by Philip Chiappini

    Help aggregating calculations with INDEX() and LOOKUP() functions

    Philip Chiappini

      Hi,

       

      I've got this chart that is currently visualized by day. I need to aggregate by sprint (three week chunks of time). For the most part this is easy, but for the desired trend line I'm using this calculation:

           (INDEX()-1) * (([Current Scope])/(WINDOW_MAX(MAX([DAY_DATE]))-WINDOW_MIN(MIN([DAY_DATE]))))

       

      I'm finding it extremely difficult to get the results I want when aggregated to the sprint level.

       

      I'm pretty sure I understand why--because of the partitioning when trying to display by sprint but calculate by day, but I can't think of a workaround.

       

      Any help would be much appreciated.

       

      Thanks,

          

       

      Daily Burnup.jpg