average condition -urgent requirement

[bhavvibudagam]

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.

[sunny_talwar]

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?

[sasikanth]

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.

[Anonymous]

Hi, try this:

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

Regards!

[bhavvibudagam]

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

[bhavvibudagam]

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