Interactive Filter limitations
Can we get interactive filter options that work like quick filters do?
For Dates I'd love to be able to just type in the date range as opposed to having to use the current option. Range selector is just not very functional.
For lists that could be in the hundreds, it would be nice to have search functionality
Also I'm having issue getting my slicers to order themselves correctly. I have a date range slicer beastmode:
(CASE
when CURRENT_DATE()-`date` < 8 then '0 - 7 days'
when CURRENT_DATE()-`date` < 31 then '8 - 30 days'
when CURRENT_DATE()-`date` < 61 then '31 - 60 days'
when CURRENT_DATE()-`date` < 91 then '61 - 90 days'
when CURRENT_DATE()-`date` < 181 then '91 - 180 days'
when CURRENT_DATE()-`date` < 366 then '181 - 365 days'
else '+366 days'
end)
And a dummy version to order them:
(CASE
when CURRENT_DATE()-`date` < 8 then '1'
when CURRENT_DATE()-`date` < 31 then '2'
when CURRENT_DATE()-`date` < 61 then '3'
when CURRENT_DATE()-`date` < 91 then '4'
when CURRENT_DATE()-`date` < 181 then '5'
when CURRENT_DATE()-`date` < 366 then '6'
else '7'
end)
But it isn't ordering based on the dummy version. It's ordering it as such (attached file)
If you know how to get it to order correctly please let me know.
Comments
-
The filter cards always sort in either ascending or descending order based on the field it is displaying.
I think a nice feature request would be to have to ability to sort these by another field.
However, as a workaround, you could try using this as your beastmode:
(CASE
when CURRENT_DATE()-`date` < 8 then ' 0 - 7 days'
when CURRENT_DATE()-`date` < 31 then ' 8 - 30 days'
when CURRENT_DATE()-`date` < 61 then ' 31 - 60 days'
when CURRENT_DATE()-`date` < 91 then ' 61 - 90 days'
when CURRENT_DATE()-`date` < 181 then ' 91 - 180 days'
when CURRENT_DATE()-`date` < 366 then ' 181 - 365 days'
else '+366 days'
end)By adding some spaces at the begining of the names, it should cause the fields to sort correctly now.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
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
- 89 SQL DataFlows
- 556 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 10 App Studio
- 27 Variables
- 578 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive