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.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
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
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 561 Beast Mode
- 8 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive