Hello,
I have 2 CSV data sources with columns <timestamp, value>, in descending order by timestamp.
I want to create a single line chart with 2 lines, with timestamps sorted ascending as argument. Also, I want the format of the timestamps on ox axis to be "HH:mm:ss" (ex: 12:47:18).
I tried to use a calculated column: timestamp.ToString("HH:mm:ss") and to sort the series data by Argument ascending. But there are issues with the sort when the timestamps are from many days.
Is it any method to specify a custom timestamp format for the ox labels while using the entire timestamp format (ex: 2020-10-02T12:47:18.000Z) on sorting?
I attached a .mrt file to showcase the problem.
Thank you,
Darius
Line chart OX labels:timestamp format
-
- Posts: 17
- Joined: Tue Sep 01, 2020 8:45 am
Line chart OX labels:timestamp format
- Attachments
-
- chart-timestamp-label-format.mrt
- (97.22 KiB) Downloaded 183 times
-
- Posts: 6245
- Joined: Tue Mar 20, 2018 5:34 am
Re: Line chart OX labels:timestamp format
Hello,
Sorry, maybe we did not exactly understand your task. Could you explain your issue in more detail, which result do you need?
Thank you.
Sorry, maybe we did not exactly understand your task. Could you explain your issue in more detail, which result do you need?
Thank you.
- Attachments
-
- Screenshot 2020-11-09 213352.jpg (97.74 KiB) Viewed 2328 times