Forum Discussion

sophie63's avatar
sophie63
Helper I
9 years ago
Solved

Date sorting problem

I have an issue with my x-axis which is not sorted in chronological order. I created a column to ahh index from 1 (jan 2016) to 15 (Mar 2017) but even the index are not well sorted.

 

 How can I solve this issue?

Need Help

3 Replies

  • sophie63's avatar
    sophie63
    Helper I
    9 years ago

    Hi,

    I have an issue with my x-axis which is not sorted in chronological order. I created a column to ahh index from 1 (jan 2016) to 15 (Mar 2017) but even the index are not well sorted.

     

     How can I solve this issue?

     

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      9 years ago

      sophie63

       

      hi, your index is type number or text?. Should be number.

       

       

      • sophie63's avatar
        sophie63
        Helper I
        9 years ago

        Vvelarde indeed it was Text instead of number I  figured that out after posting ! I changed the type and the problem is solved. Thanks! :)