How does the dashboard level filter work?
Can someone explain how the filter in the upper right part of the dashboard works?
Does it filter charts by all dates that exist within their datasets? For example, if I have a dataset that has multiple date fields (registration date, order date, shipping date, returned date, etc.) and I select a date range of 1/1-1/7... does it filter out all rows of data in which any of the date values fall outside that range?
Or does it only filter charts with dates?
Best Answers
-
Good morning @NathanDorsch
This is the equivalent of going into every card details present in your dashboard and adjusting the date range that is next to the title one at the time. the "Choose Date" in the top right corner does it for you all at once.
as long as the card is using a valid Date field , it does not matter if in one card the name of the field is 'Date' and in other cards the name is 'Date_Adjusted'... each card will adjust accordingly based on the date field it uses independently ... pretty cool 👌
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2 -
It will filter out all rows in the dataset that have an order date that doesn't fall within that week
It will only filter based on the date field being used in your selector not all the date field in your dataset
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@NathanDorsch the date filter on the dashboard operates on each card's respective date filter. So for your example - the page filter for 1/1/22/-1/7/22 means that the card you created will filter on order date where it falls in the range 1/1/22-1/7/22.
If you created another card on the same dashboard, and the card's date filter was based on registration date, then applying the page filter 1/1/22-1/7/22 would mean card 1 would be as above, and the new card 2 would filter for registration date in 1/1/22 - 1/7/22.
0
Answers
-
Hi @NathanDorsch, yes the 'Choose Date' filter applies to any card on the dashboard where the dataset has some date field. In terms of a dataset with multiple data fields, it may take the field that is most common across the other datasets involved in the dashboard or a date field with the largest range.
9 -
Good morning @NathanDorsch
This is the equivalent of going into every card details present in your dashboard and adjusting the date range that is next to the title one at the time. the "Choose Date" in the top right corner does it for you all at once.
as long as the card is using a valid Date field , it does not matter if in one card the name of the field is 'Date' and in other cards the name is 'Date_Adjusted'... each card will adjust accordingly based on the date field it uses independently ... pretty cool 👌
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2 -
Thanks guys, I'm still a little confused. Let's say I have a dataset with the following date fields: registration date, order date, shipping date, returned date. Each order is captured on one row with all 4 of these date fields. And these dates of course could cover a wide range of time for one particular value.
Let's say I create a card which is factoring in the order date... and I filter with the page filter to 1/1/22-1/7/22. Will this filter out all rows in the dataset that have an order date that doesn't fall within that week? Or will it filter out all rows in the dataset that have any date field that doesn't fall within that week?
0 -
It will filter out all rows in the dataset that have an order date that doesn't fall within that week
It will only filter based on the date field being used in your selector not all the date field in your dataset
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@NathanDorsch the date filter on the dashboard operates on each card's respective date filter. So for your example - the page filter for 1/1/22/-1/7/22 means that the card you created will filter on order date where it falls in the range 1/1/22-1/7/22.
If you created another card on the same dashboard, and the card's date filter was based on registration date, then applying the page filter 1/1/22-1/7/22 would mean card 1 would be as above, and the new card 2 would filter for registration date in 1/1/22 - 1/7/22.
0 -
@NathanDorsch the date filter on the dashboard operates on each card's respective date filter. So for your example - the page filter for 1/1/22/-1/7/22 means that the card you created will filter on order date where it falls in the range 1/1/22-1/7/22.
If you created another card on the same dashboard, and the card's date filter was based on registration date, then applying the page filter 1/1/22-1/7/22 would mean card 1 would be as above, and the new card 2 would filter for registration date in 1/1/22 - 1/7/22.
0 -
@NathanDorsch the date filter on the dashboard operates on each card's respective date filter. So for your example - the page filter for 1/1/22/-1/7/22 means that the card you created will filter on order date where it falls in the range 1/1/22-1/7/22.
If you created another card on the same dashboard, and the card's date filter was based on registration date, then applying the page filter 1/1/22-1/7/22 would mean card 1 would be as above, and the new card 2 would filter for registration date in 1/1/22 - 1/7/22.
0 -
When you configure a card, if you're displaying multiple dates on the axis, you can choose which column you filter on based on the Date Range Field.
Typically the field will default to the first field you show on the card.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
@NathanDorsch the date filter on the dashboard operates on each card's respective date filter. So for your example - the page filter for 1/1/22/-1/7/22 means that the card you created will filter on order date where it falls in the range 1/1/22-1/7/22.
If you created another card on the same dashboard, and the card's date filter was based on registration date, then applying the page filter 1/1/22-1/7/22 would mean card 1 would be as above, and the new card 2 would filter for registration date in 1/1/22 - 1/7/22.
0
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
- 603 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 388 Distribute
- 111 Domo Everywhere
- 271 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 9 Domo University
- 30 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive