12 week average for a designated column
Hello, I'm trying to write a Beastmode that calculates the 12 week average. The column I want to average is "Net Cost" and the date column is "Week Start Date".
The end goal is to have a beastmode that I can use as a value on a table that shows each distinct "Week Start Date" and the 12-wk-avg of Net Cost preceding that Week Start Date.
Even though it's not working, I'll attach a screenshot of the beastmode as it currently stands.
What am I doing wrong?
Thanks!
Best Answer
-
Are you getting an error? Or just the wrong number? It looks like you are totaling 13 numbers (current week plus last 12) and then dividing by 12. Depending on what you are wanting to do, I would either drop the current week, or the last week.
This post has good documentation on this if you haven't already looked at it.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
Are you getting an error? Or just the wrong number? It looks like you are totaling 13 numbers (current week plus last 12) and then dividing by 12. Depending on what you are wanting to do, I would either drop the current week, or the last week.
This post has good documentation on this if you haven't already looked at it.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive