Average Response Time

[bhavvibudagam]

Hi,

Can any one please help me to calculate the Average Response Time.

The requirement is to calculate the Avg Response Time for animal calls.

For the count of Animal calls i have used this expression i.e

=Count({<CALL_TYPE={'ANIMAL'},PRIMARY_UNIT_NEW={'045*'}>}EID)+Count({<CALL_TYPE={'NOISE'},CALL_SUB_TYPE={'DOGCOMP'},PRIMARY_UNIT_NEW={'045*'}>}EID)

now to calculate the Avg Response Time for animal calls how to calculate.

I have the Response time field also.

Thanks.

[sunny_talwar]

This?

=(Sum({<CALL_TYPE={'ANIMAL'},PRIMARY_UNIT_NEW={'045*'}>} [Response Time])+Sum({<CALL_TYPE={'NOISE'},CALL_SUB_TYPE={'DOGCOMP'},PRIMARY_UNIT_NEW={'045*'}>} [Response Time]))

/

(Count({<CALL_TYPE={'ANIMAL'},PRIMARY_UNIT_NEW={'045*'}>}EID)+Count({<CALL_TYPE={'NOISE'},CALL_SUB_TYPE={'DOGCOMP'},PRIMARY_UNIT_NEW={'045*'}>}EID))