Calculating day average based on hourly numbers calculation?
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.