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.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 1 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 510 Automate
- 114 Apps
- 388 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive