Current week data is showing when date rate is set as last x weeks

I have a couple of cards where I set the date range for "last 4 weeks". However, data from current week is still showing up. Anybody know what I can do to make sure the current weeks' data doesn't get pulled in? Thanks.
Best Answer
-
How about setting a parallel date value field to whatever date you really want your view to be based on, but only populate values through the end of the prior week. Leave current week date values empty, and set your lookback to 5 weeks. "Last..." naturally wants the current period to be inclusive - you are forcing the current period OUT, but you still want the 4 lookback, so resetting it to 5, and giving no consideration to the current week since none will pass your test, should get you the 4 you are looking for.
I'm sure there are other ways to approach this, this is just the first one that comes to mind.
**Say thank you by clicking the 'thumbs up'
**Be sure to select the answer that represents the best solution and mark as "Accept as Solution"1
Answers
-
How about setting a parallel date value field to whatever date you really want your view to be based on, but only populate values through the end of the prior week. Leave current week date values empty, and set your lookback to 5 weeks. "Last..." naturally wants the current period to be inclusive - you are forcing the current period OUT, but you still want the 4 lookback, so resetting it to 5, and giving no consideration to the current week since none will pass your test, should get you the 4 you are looking for.
I'm sure there are other ways to approach this, this is just the first one that comes to mind.
**Say thank you by clicking the 'thumbs up'
**Be sure to select the answer that represents the best solution and mark as "Accept as Solution"1 -
@VikkiChuChu, did ckatzman's reply help you out?
0 -
Yes, thank you.
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
- 655 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive