Line chart OX labels:timestamp format
Posted: Thu Nov 05, 2020 12:48 pm
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
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