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.
Retrieving data ...