How do I calculate current year WTD sales and previous year WTD sales?
I'm trying to calculate this week's WTD sales through yesterday and compare it to the same WTD sales for last year. Our week starts on Monday and ends on Sunday and I can't quite get our numbers to tie to a check that I've built in Excel.
Here is the formula I'm using for this year's WTD sales in Domo:
SUM(CASE
WHEN WEEK(`date`,22) = WEEK(current_date()-1,22)
AND YEAR(`date`) = YEAR(CURRENT_DATE()-1)
AND DAYOFWEEK(`date`) < DAYOFWEEK(CURRENT_DATE()-1)
THEN `totalsales`
END)
Any ideas on how to fix this?
Comments
-
Hi,
Is anyone able to help out with this request?
Thanks,0 -
Looking over it, the logic behind this makes sense. Is it possible that the [mode] part of the function is causing the mismatch? I'm not super familiar with the WEEK function, but I didn't see '22' as an option.
0
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