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.
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive