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 toany 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 toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 459 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 186 Visualize
- 250 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive