I have a set of data with a timestamp that changes with the order of milliseconds. I would like to add in my report a Line chart (or similar) showing the data as a function of the timestime. Unfortunately it appears that the LineChart allows you to lower the base unit only to seconds and not milliseconds.
Is there any way to force the millisecond time?
As a workaround I tried two things:
First, to plot the data adding as cathegories the milliseconds, seconds, minutes, and h of the data. It works, but to be honest is not very pretty (see Img0.png)
Alternatively, I also tried to generate a Calculated field where I substract the Timestamp of the data with the First Timestamp, in order to have a time that starts from 0. From this Field, I wanted to manually calculate the milliseconds (adding also seconds, minutes, etc) in order to make a Scatter graph. However the obtained field has some issues. In the dataSource it appears as date, showing it has Minute, Second, etc, but if I try to refer to these subfields it gives me errors. I attached two pictures, one with the error shown if I just make a preview of the two data calculated, the other showing the Calculated Field (note that for the second one I'm simply collecting the Millisecond field).
Could you please help me with this, maybe with an example? thank you in advance!
Keep in mind that I would prefer to resolve it within Telerik, without the need to use outside code/calculations.