Forum Discussion
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
- AnonymousNot 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
- DH27Frequent Visitor
Hi Anonymous
thanks for your comment, the data type is text.
Unfortunately, I don't have the sort by feature for this visual.
- AnonymousNot 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
- DH27Frequent 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.