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.

       

      -Jesse