Charting

Charting

MONTH ON X AXIS NOT IN CALENDER ORDER

The month on the X axis is not in calender order.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Best Answer

  • Member
    Answer ✓

    That doesn't seem to work.  I have tried filtering it by the month, and does not make a difference.  Is there a setting that would allow us to change this order, or a formula in beast mode that may work?

     

     

Answers

  • Contributor

    make sure the date field your using is loaded as a date or datetime data type. Also, i would sort the chart by the date field to make sure it stays in order. 

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • Member
    Answer ✓

    That doesn't seem to work.  I have tried filtering it by the month, and does not make a difference.  Is there a setting that would allow us to change this order, or a formula in beast mode that may work?

     

     

  • Contributor

    Sounds like the date value you are uising is not a Date data type. You have couple of options:


    1. You may want to consider fixing that through your data load process.
    2. Create a Beast Mode calc using a CASE function to map Jan-Dec text values to a numeric sortable value, and drop that into the Sort criteria.
    3. Try converting your data column using the following beast mode and see if that will fix the issue. 

      STR_TO_DATE('DateCol','%m,%d,%Y')

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
This discussion has been closed.