Quick Filter Sort Order
Does anyone know what drives the sort order of a quick filter? I have one example that appears alphebetical but then I have a Day of Week category that is totally non-sensical.
Comments
-
I haven't played a whole lot with quick filters yet, but did you try sorting the data by your date field first? It may just be pulling in each weekday name as it encounters them in your data set.
0 -
It could be sorted by highest corresponding value. For example, if Friday is worth 6 and Monday is worth 4, Friday will be listed first.
If that's either irrelevant or there's a different criteriato follow it may default ot that. For example I have a quick filter based on a beast mode calculation that takes year-as-a-whole-number (2017) and concatenates it with 'Q' and quarter-as-a-whole-number, giving me, for example, 1998 Q 3, 1998 Q 4, 1999 Q 1 and so on, in quarter order.
It doesn't recognize the written days of the week as such, it jsut recognizes them as random strings.
Weird that it isn't in alphabetical order, though. I agree with Scott Thompson here; try sorting by day of the week if possible.
0
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
- 659 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 778 Automate
- 190 Apps
- 482 APIs & Domo Developer
- 83 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive