Beast Mode Week Revenue Calculation
Hi folks,
This should be a fairly straight forward question. So I need to do a calculation that finds the revenue from 12 weeks ago. I know that I can use weekofyear(). However, since it's only 6 weeks into 2018. This method wouldn't work untill later in the year. Is there a beast mode function that allows me to actually get the weeks from 2017? A friend on Domo suggested this as a solution but it won't give me the revenue from 12 weeks ago. Please see screenshot for details.
Thanks,
Leon
Comments
-
Hey Leon,
To get revenue for the last 12 weeks, you could create a beast mode that utilizes the date_add() function.
example:
SUM(Case when `Date` >= DATE_ADD(`Date`, Interval -12 Week) and `Date` <= NOW() then `Sales` else 0 END)EDIT: Just saw your example that you included. Based on the example when the revenue from last week is greater than 100 and the gross revenue from 12 weeks ago is less than 10, then last weeks gross revenue?
My solution probably isn't the one you're looking for, but I might be able to help with some clarification of what you're aiming for. Last weeks revenue based on 12 weeks ago?
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2 -
Hi Thanks for your reply.
And yes that is exactly what I was trying to do. I wanted to get the weekly revenue from 12 weeks ago.
I'll try to play around your functions and see if it will work and let you know
0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 283 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 565 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 593 Beast Mode
- 13 App Studio
- 28 Variables
- 588 Automate
- 143 Apps
- 417 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 96 Manage
- 93 Governance & Security
- 15 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive