Short for no patient
Warning: default time unit is seconds. firstwatch customer service will not convert seconds to minutes for you. You have to do your own.
Step 1
on xxx_xyTableToPoint layer, these 3 time field is text type, after append to xxxx_raw layer, these 3 time fields becomes to double, so you can convert seconds to minutes by divide 60
Step 2
So far all 3 times column don't have null value. You can use arcade or VBsript, but don't use Python, Python will cause all value set to null, you will have to do it from scratch again.
Recommend Use VBscript at this time. see the reason why below steps.
Don't convert 0 and negative value to null value yet. You should do it after convert from seconds to minutes.
Step 3
Arcade to convert seconds to minutes, Turn out time
Warning: There is ESRI bug, if you use Arcade, null divide by 0 should be null, but Arcade will output 0, you have to convert 0 to null again manually.
Step 4
convert seconds to minutes, Response Time
Warning: Use vbscript, no bug, VBscript, null divide by 60, out put null, which is correct
Step 5
convert seconds to minutes, On Screen Time
warning: Never use python, does not work, null divide by 60, cause all value output as null, see warning message complaining
Final result, after convert seconds to minutes, you should see this
Convert all 0 and negative value to null , 0 and negative time these are invalid time, will not count for average turn out time.
Step 6
select all negative time or 0 value
Step 7
Turn out time, convert all these negative time or 0 as null value, since these are invalid time, will not count for average turn out time. see https://transparentgov.net/cleargov1/1570/how-to-convert-0-to-null-value-arcpro-part-7-911-firstwatch?show=1570#q1570
Step 8
repeat step 1 and 2 for Response Time
Step 9 repeat step 1 and 2 for On Screen Time
Long story
Understanding these field, Turnout time, Response time, on screen time
The Turnout time column is measuring the time difference from a unit's Assigned time and their Enroute time.
The Response time column is measuring the time difference from a unit's Enroute time and their Arrived at Scene time.
The on screen time column is measuring the time difference from a unit's Arrived at Scene time and their Depart Scene time.
These field in firstwatch web site formated as
[Hours : Minutes : Seconds]
However, when you click excel button to download in excel file, these field will be formated as "Second"
To change these trigger format, or add more fields, contact customer support
I found some fields are empty which should have data. When I download it, it is empty also. see screen
I have called customer service. They said you have to click 'Reload' instead of "event list", because "reload" is historic data. Yes, this time I got all previous empty field populated. see below
To reset password, configure your account, setup your account, go here
