Sum Previous 4 Weeks of Sales Together
Hi,
I'm trying to sum our weekly sales data into 4 weeks of sales. For example, if we had $10 in sales each of the past 4 weeks, the value returnded should be $40.
I'm using this function:
SUM(CASE
WHEN WEEK('Week Beginning') > WEEK('Week Beginning') - 4
THEN 'Sales'
ELSE 0
END)
But this is just returning the sales for last week, not the aggregate of the past 4 weeks.
Thank you
Comments
-
We may need to see a sample of columns and values.
That being said, try putting a MAX function in front of the second WEEK statement. This way, you're taking all the weeks which are within 4 weeks of the most current week.
At some point, you'll need to aggregate the Sales, but perhaps you're doing that in the output. If it's not working try summing the THEN.
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Hi
The Max Function would not work in this case
Try using 'Today' instead of 'Week Beginning' on the second instance.
Also try addign YEAR() to the beastmode otherwise the logic will break during the first 3 weeks of the year
1 -
Thanks All! I'm going to play around with your suggestions and see how it turns out.
1 -
Good thinking @rado98 on those first few weeks!
@user17569 - Make sure to let us know what works, and if there's anything we can add.
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive