Creating reports and dashboards | Stimulsoft community forum

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?

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.

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.

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

Hello,

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

Thank you.

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

Hello,

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

Thank you.