How do I change my week to Mon - Sun and fix this report?
I have an auto weekly report that shows the dates of a week and the corresponding data. The report goes out on Monday and I need it to show the previous two weeks (Mon - Sun), not including the current Monday data.
Right now I have manually typed the dates (if 1.2.23, 1.3.23..then week = 1/2 - 1/8) and select the next week each friday before I log off.
How do I make this automatically update to the correct week and data?
Example: Report goes out Mon 1/16/22
1/2 - 1/8: DATA
1/9 - 1/15: DATA
Best Answer
-
Since you are sending this every Monday, you can use this beast mode and put it in your filters and then filter to Include.
CASE when `date` >= DATE_SUB(CURRENT_DATE(), INTERVAL 14 day) and `date` < CURRENT_DATE() THEN 'Include' ELSE 'Exclude' END
You would need to change
date
in my example to the actual date field in your dataset. When filtered to Include, this will only show rows where the date is in the last 14 days and before today.**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.1
Answers
-
@kathint303 Where are you manually typing the dates now? Is it in the date range or somewhere else in the analyzer?
0 -
Since you are sending this every Monday, you can use this beast mode and put it in your filters and then filter to Include.
CASE when `date` >= DATE_SUB(CURRENT_DATE(), INTERVAL 14 day) and `date` < CURRENT_DATE() THEN 'Include' ELSE 'Exclude' END
You would need to change
date
in my example to the actual date field in your dataset. When filtered to Include, this will only show rows where the date is in the last 14 days and before today.**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.1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive