DOMO chart doesn't sort in Month order? help

Lu_zhang

I want the month "JAN, FEB, Mar" (in text) to be shown in order, but it doesn't work. how to adjust it? thanks,

jessdoe

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

Jonathan53891

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.

jessdoe

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

Jonathan53891

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.

david_cunningham

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.