Line chart XAxis Time format

[adbaisan]

Hello, I have a line chart with a timeline in seconds (0,1,2,...) and I would want my X Axis to display minutes:seconds. I set the format to X Axis to "00:00", the column is set with DateTime type, DateTime step in X Axis is set to Second, but the timestamps are looking like "00:99", "01:74", they don't stop at 59 looking like seconds. Is there a way to make my timeline display in minutes:seconds? Maybe I am missing a property or the format of my timeline i wrong?

[HighAley]

Hello,

What id the format of the column that you use to pass the seconds?
The chart can't convert integer value to minutes and seconds automatically.
Maybe you should add a Calculate column that will convert seconds to DateTime or TimeSpan.

Thank you.

[adbaisan]

Thanks for the quick reply. The format is indeed integer, but if you could tell me what format should I send it it won't be a problem to change it.

[adbaisan]

Can you tell me what is the default datetime and timespan type format?

[Lech Kulikowski]

Hello,

It depends of the localization setting or Culture property of the report.

Thank you.

[adbaisan]

Just for others to know, I set the time field to Timespan and removed the format from the chart, data in time field is in format "hh:mm:ss", still wanted "mm:ss" format but that's a smaller issue

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.