4 Replies Latest reply on Jun 19, 2018 5:16 PM by Jesse Zhang

    Index Week numbers & Avg. Last 3 periods

    Jesse Zhang

      Hi Everyone,


      I have struggled with this problem for the past 2 days. Here is the problem:


      - I have a dataset with product names, load dates, and performance indexes. Each product have different load dates, also different number of load dates. (attached workbook is a sample, actual data has about 2 M rows)


      What I want to do is:

      - to find the rate of change in performance for each product, based on it's own last 3 periods of loads (weeks)


      The bottleneck here for me is that the dates are all over the place, I tried to normalize the date range with DateDiff, but there are gaps between some of the load dates, and I don't really know a good way to calculate average of last 3 indexes, i have tried Window_Avg. but it didn't work.


      I would prefer to do this without using table calc if possible.


      Thanks in advance for any help.