DOMO chart doesn't sort in Month order? help

Lu_zhang
Lu_zhang Member
in Charting

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

image.png
Tagged:

Best Answers

  • jessdoe
    jessdoe Contributor
    Answer ✓

    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
    Jonathan53891 Contributor
    Answer ✓

    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.

Answers

  • jessdoe
    jessdoe Contributor
    Answer ✓

    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
    Jonathan53891 Contributor
    Answer ✓

    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
    david_cunningham Coach

    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! ✔️**

Categories