Thanks for the input. The field was actually called IncidentID so the brackets are not necessary.
Erik, looking at your file it looks like we have the same settings in the chart object. I enclose the application that I am working with. Looking in the chart you can see that:
1. The sorting is not correct. The timestamps are not displayed in a chronological order
2. The same timestamp is displayed multiple times in the chart.
supportpoint_lab.qvw 545.5 K
Hi, I couldn't open your application.
It sounds like maybe your rounding doesn't work, the time fields might be displayed similarly but they might still be different for like a millionth of a second.
Try the following:
Date(Floor(Timefield, (1/24) ), 'hh:mm')
Date(Floor(Timefield, 0.041666666666666), 'hh:mm') as IncidentHour.
or if you have a timestamp rather than just a time field
Time(Floor(TIME(FRAC(TIMESTAMPFIELD), 'hh:mm:ss'), (1/24)) 'hh:mm')as IncidentHour
I was able to open your file, judging on your field names this should work: