Date filter greyed out - multiple date columns in a table visual
Hi there,
When I drag a second date column into a table visual, the date filter auto changes to match the new date column and greys out. It doesn't happen every time though so if someone can send the documentation or explain that would be appreciated.
In this scenario, I am trying to bring a create date into the table while keeping the batch date as the filter.
Answers
-
Hi @MichelleH - here I want the 'created date' field in the card because I want to see when the record was created at source however I want the card to remain filtered by the 'batch date' - the date it was appended into Domo.
0 -
Hi @MichelleH yeah I did tried this, this is the order:
Even when I remove the create date it stays as a filter greyed out. I have to 'undo' until it returns to latest update (alias for batch date)
0 -
Update: (@MichelleH)
It works now, I removed both dates, added the created date first then added the batch date.
It must take whatever the last date field added is and auto set this as the date range field filter for some reason.
Thanks for the help!
1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive