How to get Domo to recognize numbering as 1,2,3,... instead of 1,10, 100, 110,...?
Hi, I have a daset that I want to build a Sumo card on.
But as I build the card, it's clear that Domo tried to sort the categories by itself, causing the view to be something I don't quite want.
I tired adding numbers before each category, but instead of arranging the numbers by 1,2,3,... Domo somehow arranged it to be in this structure 1,10,110,...
Why does Domo behave this way and how do I solve this problem?
Thanks.
Comments
-
So the reason it's doing this is that your category columns are being viewed as a text column instead of numeric.
What you would need to do is add a separate column for ordering and then sort by this new ordering column. That will keep your categories in the correct order.
Let me know if you have any other questions on how to do this,
Valiant
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
It sounds like you're referring to Domo sorting by strings alphabetically, and 10 does come alphabetically before 2. What you need to do is separate your category names from the way those categories sort.
This is often done with a custom beast mode calculation or a separate column that provides the sort order priority.
The other option, if you want to maintain the number category combination, would be to zero-fill the numbers in order to force alphabetical sorting, like 001, 002, 003... 010, 011, 012... 100, 101, 102, etc.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive