Hi, I have a hidden field (TimeCopy) with calculate format-date(${InterceptTime}, '%H:%M') to extract the time only from a DateTime field. The field automatically outputs to field type String, which doesn’t display the way I need it to when displayed in a serial chart format in the Dashboard. Each timestamps are shown as one bar in the chart, so 18:25 and 18:30 would be separate bars as below. I need a chart to show in hourly ranges, with every entry within the same hour counted and displayed in a single bar.
I tried creating a serial chart with just the datetime field instead, with Parse dates ticked and minimum set as Hour. This still displays all the different dates as well, so doesn’t return what I am looking for.
Is there a way to get the Time field (time only extracted from a DateTime field) to output as just Time, and not string? I’ve tried setting the bind::esri:fieldtype as esriFieldTypeDate, or bind::type as Time, but in either cases the field does not output any data.
Below is an example of what I am trying to achieve.
The DateTime field needs to be kept as DateTime, as I’ve set it up to calculate ‘time elapsed’ between two DateTime fields.
It seems maybe in the TimeCopy field, I could find a way to replace all the dates from the DateTime with a default date, so that when I select Parse Dates and Minimum Period as Hour, only the hours of the day are displayed like the above.
Though I know the end result I would like, I’m unsure how to replace the date from DateTime and copy the time from the DateTime together into the same field? Or whether there is an easier way to turn the TimeCopy field into a Time only fieldtype?
Thank you, any ideas/advice would be very much appreciated!
Accepted Solutions
Oh, you're right, I didn't think about that.
For the arbitrary date, just hard-code a value into the formula in the standard YYYY-MM-DD format.
format-date(${InterceptTime}, '1970-01-01 %H:%M') 
