Mapping "month" to "week" data
I have a dataset with sales report by week and year (e.g., Week = 1, Year = 2022) and want to be able to append a month value so we can look and filter by MTD data.
Is there a way to 'calculate' a date either through beast mode or in ETL to map the month associated with the week of the year?
Best Answer
-
There isn't a simple way to do this as a week of the year can straddle two different months so you wouldn't be precise with the months when you calculate it this way. How would you want the monthly amounts to be calculated? Based on the start of the week or the end of the week? You wouldn't be able to get precise monthly numbers.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
There isn't a simple way to do this as a week of the year can straddle two different months so you wouldn't be precise with the months when you calculate it this way. How would you want the monthly amounts to be calculated? Based on the start of the week or the end of the week? You wouldn't be able to get precise monthly numbers.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Got it - that makes sense, thanks!
0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 559 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 574 Beast Mode
- 12 App Studio
- 28 Variables
- 582 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 26 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 356 Distribute
- 95 Domo Everywhere
- 259 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive