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
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 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
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive