Date range filter not working properly
Hi,
I have a query on the date range filters in cards. I have a card and filtered date range to show last 12 months by month, and then if I just select the date range ‘this year, by month’, instead of reformatting the card to show those months only(inside the analyzer when I select This year, I am able to see this year months but outside the analyzer which is after saving the card when I filter as This year by month last year months are visible but there is no data displayed for previous year), I can still see the beginning of months as blank.
There are two fields (date, department) that I have sorted. When I remove department field from the sort section the date range filter works perfectly fine.
Let me know if I am missing something.
Thanks
Comments
-
your use case sounds convoluted and it sounds like you have conflicting filters.
If i understand you,
in the CARD you're filtering for the last 12 months.
in the DASHBOARD you're filtering for the CURRENT Year.
The dashboard will override your filters and limit you to data from the current year, (i.e. 9 months).
Best practices says, only put filters on the card that you DON'T plan to apply at the dashboard.
It's unclear to me why adding or changing Department is having any impact on this... if I had to guess it's a red herring (ignore this piece of interaction) and design assuming base functionality works as previously described.
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"0 -
Hi @jaeW_at_Onyx ,
I have set the date range to Last 12 months in analyzer. When I filter to Current year, last year months are visible but with no data. In general, when we filter for Current year, only current months should be displayed.
I did not add the card to dashboard.
Anyway, the filters are working fine now even though I haven't change anything from my end.
Thanks
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive