topic Re: average condition -urgent requirement in QlikView

average condition -urgent requirement

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

Hi can any one please help me.

i need to calculate average calls for service per shift per day.

Dimension is Shift (Day, Eve, Mid)

I need to put the below logic in expression.

AVG CFS per shift per day = Total (CFS) / # of days / # of officers for that shift

for officers I have the field with officer name

how to put this logic in expression please help me to do per day need to calculate the CFS.

Re: average condition -urgent requirement

sunny_talwar — Thu, 15 Sep 2016 10:33:41 GMT

Is this # of days or # of shifts?

Total (CFS) / # of days / # of officers for that shift

Would you be able to share few rows of data with the expected output?

Re: average condition -urgent requirement

sasikanth — Thu, 15 Sep 2016 10:45:12 GMT

HI,

Try to add Day dimension also to the chat.

so your dimensions would be : Day,Shift and Expression: Total(CFS)/No.of Officers. (if not correct aggregate it over dimension fields)

Turn on stacked mode and you can see better visualization.

Re: average condition -urgent requirement

Anonymous — Thu, 15 Sep 2016 10:58:39 GMT

Hi, try this:

COUNT(TOTAL <Day, Eve, Mid> Calls)/Count(Day)/COUNT(TOTAL <Day, Eve, Mid> Officers)

Regards!

Re: average condition -urgent requirement

bhavvibudagam — Thu, 15 Sep 2016 14:49:09 GMT

Hi,

This is the complete logic

Average should be dividing by the total number of distinct days in the date range. Should take a count of all the distinct EIDs in the data available, divide by the distinct number of days in the year, and then divide by the average number of officers working on that shift.

I have day field,year field,officername field and shift for the count have EID

Pleas help me to put the above one in expression

Thanks

Re: average condition -urgent requirement

bhavvibudagam — Thu, 15 Sep 2016 14:50:13 GMT

Hi,

This is the complete logic

I have day field,year field,officername field and shift for the count have EID

Pleas help me to put the above one in expression

Thanks