Calculating day average based on hourly numbers calculation?

[haneeshmarella]

Hi guys,

As above, I have the first 5 columns. The 6th column is how I calculate hourly efficiency.

How can I calculate average hourly efficiency for that day without having to calculate the column 'Hourly Efficiency' and then take an average of it? I am trying to do that in a KPI text box only for the average hourly efficiency for that day.

Thank you.

[sergio0592]

Hi, for get KPI in a text box try with :

avg(aggr( (Count of case#) / ((Head Count)*(Hourly Target Count of Case#)), Date YYYYMMDD))

[haneeshmarella]

Thank you Jean. The only correction needed was to replace Date YYYYMMDD with Time HH to take an average after calculating hourly.