filter issues

I'm having some odd issue with one of my filters and how a table somehow gets unsorted by it.
I have a table which I want sorted by "preferred URL" and then sum of "monthly page views". Without any filters applied on my dashboard, this table is properly sorted. Then when I apply a filter (CMS), it suddenly turns my sorting upside down. The pages that were at the top are suddenly sorted at the bottom (they are still included in the results as they should be).
Does anyone know what might be going on here?
Best Answer
-
That is odd. I would suggest creating a beast mode that results in numerical values to put in your sorting. For example, I would do something like this:
CASE WHEN Preferred = 'Yes' THEN 1 ELSE 0 END
Put this beast mode as your first sorting and sort descending and remove the Preferred from the sorting. See if this does the trick for you.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
That is odd. I would suggest creating a beast mode that results in numerical values to put in your sorting. For example, I would do something like this:
CASE WHEN Preferred = 'Yes' THEN 1 ELSE 0 END
Put this beast mode as your first sorting and sort descending and remove the Preferred from the sorting. See if this does the trick for you.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
I frequently encounter problems when filtering/sorting columns with null values. Marks' suggestion is good, because it will give you a column with no nulls.
0 -
Thanks @MarkSnodgrass and @DavidChurchman I'm thinking the null values must somehow be impacting this. I should be able to address this with a BM that combines them and replaces nulls with a value.
0
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 970 Connectors
- 259 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 502 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 379 Beast Mode
- 21 Variables
- 487 Automate
- 104 Apps
- 379 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 319 Distribute
- 67 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 64 Community Announcements
- 4.8K Archive