Date Filter for last day/week/month
Best Answer
-
For everyon's knowledge, you can do this by going into the calendar type card, going to Presets View in Chart Properties and selecting "Show Presets Only".
This will do the job. Cheers
1
Answers
-
At first glance I thought this was pretty straightforward. Then I started writing my solution and realized an issue. For today and yesterday you can just write a calculated field statement like this:
case when `date_field`=curdate() then 'today'
when `date_field`=curdate()-1 then 'yesterday' end
however, the issue I discovered is that you would want to include yesterday and today in the 'last one week' category.
if you are just looking at one card, I know that you can click on the date and quickly adjust the date window the card is looking at but I am not sure if that is possible from a dashboard layout. This might be a feature request.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
Hello.
I was watching a video on Youtube, in which a guy creates a "last 3 months" filter. Although I could not completely understand what he did, do you think using this feature (highlighted in the video) I can make my filter?
https://www.youtube.com/watch?v=qc5JqGWtlu8&feature=youtu.be
Hamza
0 -
For everyon's knowledge, you can do this by going into the calendar type card, going to Presets View in Chart Properties and selecting "Show Presets Only".
This will do the job. Cheers
1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 562 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive