Forum Discussion

DH27's avatar
DH27
Frequent Visitor
6 years ago
Solved

Python Visual - datestamps on x-Axis all over the place

Hi, 

I've created some Python visualisations and for the most part, they are working just fine. 

However, there is one visualisation, where I've got either bizarre date stamps (attachment 1),

or if I convert the data to text in the query-editor, the order is getting disrupted (attachment 2).

In the query-editor, my data remains in the correct order and looks fine. 

 

Any help regarding this problem would be very much appreciated!

 

Attachment 1Attachment 2Attachment 3

 
 
  • Hi,

     

    a week has passed and I managed to narrow the problem down to the following phenomenon:

    In most of my graphs, the time stamps on the x-axis are mixed up, even though the data is sorted

    correctly in the data-menu.

    I have made another screenshot of the behaviour to further clear up the problem:

    As the visualisation is created with Python Visual, I am not able to sort the data manually in the report-menu.

    Furthermore, it looks like only the labels on the x-axis are mixed up, the data itself seems to be sorted correctly.

     

    Thanks for any answers regarding this problem.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi DH27 ,

     

    What's the data type of monat_1 column in Attachment 3? 

    Do we have sort by feature in the visual?

     

    Best Regards,

    Jay

    • DH27's avatar
      DH27
      Frequent Visitor

      Hi Anonymous 

       

      thanks for your comment, the data type is text.

      Unfortunately, I don't have the sort by feature for this visual.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi DH27 ,

         

         

        Since i can't restore your scenario, can you share your file to me if you don't have any Confidential Information?

         

        Best Regards,

        Jay

  • DH27's avatar
    DH27
    Frequent Visitor

    Hi,

     

    a week has passed and I managed to narrow the problem down to the following phenomenon:

    In most of my graphs, the time stamps on the x-axis are mixed up, even though the data is sorted

    correctly in the data-menu.

    I have made another screenshot of the behaviour to further clear up the problem:

    As the visualisation is created with Python Visual, I am not able to sort the data manually in the report-menu.

    Furthermore, it looks like only the labels on the x-axis are mixed up, the data itself seems to be sorted correctly.

     

    Thanks for any answers regarding this problem.