Calculating 7-Day Moving Average (Beastmode)
Comments
-
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"0 -
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.
1 -
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!
1 -
Here is the rank and window link:
https://knowledge.domo.com?cid=etlactionsrankandwindow
And the video:
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?
1 -
So the solution is to alter with the data set? How come you cannot do this in a calculated field ("beast mode")? Seems like something for DOMO product peeps to jump on: table calculations.
5
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive