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.” -Superman
______________________________________________________________________________________________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
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 465 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 654 ひらめき共有