DOMO chart doesn't sort in Month order? help
Best Answers
-
There are a lot of ways to accomplish this but the easiest is probably to just drag whatever column you're using for date into the "sorting" section in chart properties.
You can also create a beastmode and add that beastmode to the sorting section:
month(your_date_column)
The above options work as long as month 1 is January and Month 12 is December in your data
3 -
The reason why it is sorting in the way it is currently presented is because the months are in text value. Since it is being sorted in ascending order, it is sorting from A to Z (Feb, Jan, Mar). The easiest solution would be to drag-and-drop a date field into the "Sorting" section (Order Date in your provided screenshot could potentially work). Then sort the table in ascending order to achieve the results you are looking for.
3
Answers
-
There are a lot of ways to accomplish this but the easiest is probably to just drag whatever column you're using for date into the "sorting" section in chart properties.
You can also create a beastmode and add that beastmode to the sorting section:
month(your_date_column)
The above options work as long as month 1 is January and Month 12 is December in your data
3 -
The reason why it is sorting in the way it is currently presented is because the months are in text value. Since it is being sorted in ascending order, it is sorting from A to Z (Feb, Jan, Mar). The easiest solution would be to drag-and-drop a date field into the "Sorting" section (Order Date in your provided screenshot could potentially work). Then sort the table in ascending order to achieve the results you are looking for.
3 -
Just to expand on what @Jonathan53891 is suggesting. You are able to use different columns in your display and sort. So you can display (Jan, Feb, Mar: the text values), but can sort on a numeric field to make sure they display in the proper order.
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**2
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
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 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