Skip to content

    • Charting

    Charting

    MONTH ON X AXIS NOT IN CALENDER ORDER

    Member
    in Charting

    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.

    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

    Quick Links

    Categories