13 Replies Latest reply on Sep 25, 2018 1:08 AM by Mahfooj Khan

    How to get last 30 day average

    Alex Martino

      Hello. How do I get last 30 day average for asins USING THE MOST RECENT DATE IN MY DATA SET (as it is updated)

       

      I have a category: Polo Shirts and then I have different size/color combinations (asins)

       

      How can I calculate the daily average for the last 30 days. I think that whenever there are 0 sales for a date, the date just doesn't show up, so the formula would have to take this into account.

       

      Thanks!!