View last 2 weeks of data
Hello. I know there is an option to view Previous Week data. But how can I manage to display a week before the Previous, JUST AND ONLY the week prior.
Example
This week is 16 of the year
Previous week was 15
Pior to that, it was 14
I want a chart to display only data for week 14, and ANOTHER chart to display only Previous week's data (15)
Is there a way to show only week 14 in a chart?
Thanks in advance
Best Answer
-
I don't think there's a preset value for "Just the week 2 weeks ago" but you can do that last 2 weeks which would include both weeks which isn't what you're wanting. It could just be a simple beast mode though with a bit of gymnastics (date subtraction)
CASE WHEN `Date` > DATE_SUB(DATE_SUB(CURRENT_DATE(), DAYOFWEEK(CURDATE())), INTERVAL 14 DAY) AND `Date` <= DATE_SUB(DATE_SUB(CURRENT_DATE(), DAYOFWEEK(CURDATE())), INTERVAL 7 DAY) THEN '2 weeks ago' else 'NOT 2 weeks ago' end
And then just filter your card based on that specific value while specifying the past 3 weeks in your date selection for your card.
Granted this might add a bit of uncertainty if it says you're looking at the past 3 weeks but then are only showing a single week but you might be able to hide the date selector on your card and clearly note that this is only 2 weeks ago.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
I was just thinking of doing beast mode gymnastics, but I'd like to avoid that...
0 -
I don't think there's a preset value for "Just the week 2 weeks ago" but you can do that last 2 weeks which would include both weeks which isn't what you're wanting. It could just be a simple beast mode though with a bit of gymnastics (date subtraction)
CASE WHEN `Date` > DATE_SUB(DATE_SUB(CURRENT_DATE(), DAYOFWEEK(CURDATE())), INTERVAL 14 DAY) AND `Date` <= DATE_SUB(DATE_SUB(CURRENT_DATE(), DAYOFWEEK(CURDATE())), INTERVAL 7 DAY) THEN '2 weeks ago' else 'NOT 2 weeks ago' end
And then just filter your card based on that specific value while specifying the past 3 weeks in your date selection for your card.
Granted this might add a bit of uncertainty if it says you're looking at the past 3 weeks but then are only showing a single week but you might be able to hide the date selector on your card and clearly note that this is only 2 weeks ago.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 600 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 685 Beast Mode
- 43 App Studio
- 38 Variables
- 655 Automate
- 170 Apps
- 438 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 383 Distribute
- 110 Domo Everywhere
- 267 Scheduled Reports
- 6 Software Integrations
- 111 Manage
- 108 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive