Hi,
i have a field like '2022-12-12 18:43:41.520' and i want display '18:43:41' in the graph as x-Axis.
Foreach row i want Y-Axis the value and X-Axis his time. How I can do the conversion from Datetime to Timespan correctly?
I tried to change my field Data option to time in Chart argument but it display a number and not the time like '18:43:41'.
field Datetime to Timespan in graph
-
- Posts: 21
- Joined: Tue Apr 26, 2022 2:06 pm
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: field Datetime to Timespan in graph
Hello,
You can use ToString() or TimeSerial functions.
Thank you.
You can use ToString() or TimeSerial functions.
Thank you.
- Attachments
-
- Screenshot 2022-12-15 164217.png (26.7 KiB) Viewed 10050 times
-
- Posts: 21
- Joined: Tue Apr 26, 2022 2:06 pm
Re: field Datetime to Timespan in graph
Can i do this on graph X-Axis?
I have date in a small time interval (10 seconds) and i don't know why my x-axis write a number instead of the value...
Thanks
I have date in a small time interval (10 seconds) and i don't know why my x-axis write a number instead of the value...
Thanks
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: field Datetime to Timespan in graph
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
-
- Posts: 21
- Joined: Tue Apr 26, 2022 2:06 pm
Re: field Datetime to Timespan in graph
I noticed that with an high ratio of data it displays number, with a low ratio it displays data.
Low ration example and my expected result.
Anyway,
i attached high ration data and sample dashboard.
Thanks.
Low ration example and my expected result.
Anyway,
i attached high ration data and sample dashboard.
Thanks.
- Attachments
-
- ReportTest.mrt
- (7.78 KiB) Downloaded 209 times
-
- Example.json
- (322.56 KiB) Downloaded 208 times
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: field Datetime to Timespan in graph
Hello,
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.