<= after set analysis for Fire Department

[slpalmgren]

We are trying to create an expression that shows the % of time a call is <=300 seconds. This is what we have tried but it is not working for some reason. Anyone have any suggestions? 

=Count({<[SceneArrivalOrder]={'1'},[priority_description]={'Priority 1 Call','Priority 2 Call','Priority 3 Call','Priority 4 Call','Priority 5 Call'},
[division]={'Overland Park Fire Department'},[is_opfd_unit]={'Yes'}>} (time_arrivedatscene-time_enroute) <= '0:05:00')

/Count({<[SceneArrivalOrder]={'1'},[priority_description]={'Priority 1 Call','Priority 2 Call','Priority 3 Call','Priority 4 Call','Priority 5 Call'},
[division]={'Overland Park Fire Department'},[is_opfd_unit]={'Yes'}>} (time_arrivedatscene-time_enroute))

//[Travel (secs)]={'<=300'}>}

[techvarun]

Please share a sample app/dataset with the expected output

[sergio0592]

Hi,

What is your key for your call table? Suppose it's ID_Call. Try to pre calculate in your load statement in order to get the field with the call lenght :

time_arrivedatscene-time_enroute

And try:

Count({<[SceneArrivalOrder]={'1'},[priority_description]={'Priority 1 Call','Priority 2 Call','Priority 3 Call','Priority 4 Call','Priority 5 Call'},
[division]={'Overland Park Fire Department'},[is_opfd_unit]={'Yes'}, call_lenght={"<=300"}>} ID_Call)

/

Count({<[SceneArrivalOrder]={'1'},[priority_description]={'Priority 1 Call','Priority 2 Call','Priority 3 Call','Priority 4 Call','Priority 5 Call'},
[division]={'Overland Park Fire Department'},[is_opfd_unit]={'Yes'}>} ID_Call)