Average Response Time

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Average Response Time

sunny_talwar — Fri, 29 Jul 2016 06:12:31 GMT

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))

topic Re: Average Response Time in QlikView

Average Response Time

Re: Average Response Time