Calculating 7-Day Moving Average (Beastmode)

user09167
user09167 Member
in Archive

Hi I want to have a rolling 7 day average revenue for every day. Ideally, I would want the average revenue for 7 days previously for every day. 

Comments

  • Gimli
    Gimli Domo Employee

    Hi, 

    Here is a great knowledge base article on this subject: 
    http://knowledge.domo.com?cid=createrollingaverage

    **Say “Thanks" by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Jsun82
    Jsun82 Member

    This definitely works.  Also, it may be easier to use the ETL transform "Rank and Window" with the subfunction average for the window of 7 days depending on how your data is laid out.

     

    If there is only one data point per day, or if you can group by day without affecting what you want to see in the output, it may be a slightly simpler solution.

  • user09167
    user09167 Member

    Thanks for this response! I'm not sure how to use the Rank and Window option in the ETL and would love some guidance. From the attached screenshot, I have been guessing how to take just 1 day before and after to see what the average is but the values are not correct. Am I doing something wrong? Thanks!

  • Jsun82
    Jsun82 Member

    Here is the rank and window link:

    https://knowledge.domo.com?cid=etlactionsrankandwindow

     

    And the video:

    https://university.domo.com/videos/watch/ozZWNnYzE6i9lZiWn5F2dpeCKiyFoQGI/cat/1d40efe9078f416a95ade66fab31ee53

     

    It looks like you have set it up correctly (hard to tell without seeing the base data).  It should be calculating the average of 3 values (day before, the day itself, and the next day).  Can you let me know what calculations are actually occurring?

Categories