topic Re: Calculating day average based on hourly numbers calculation? in QlikView https://community.qlik.com/t5/QlikView/Calculating-day-average-based-on-hourly-numbers-calculation/m-p/136127#M764590 <HTML><HEAD></HEAD><BODY><P>Thank you Jean. The only correction needed was to replace Date YYYYMMDD with Time HH to take an average after calculating hourly. </P></BODY></HTML> Thu, 12 Jul 2018 16:36:47 GMT haneeshmarella 2018-07-12T16:36:47Z Calculating day average based on hourly numbers calculation? https://community.qlik.com/t5/QlikView/Calculating-day-average-based-on-hourly-numbers-calculation/m-p/136125#M764588 <HTML><HEAD></HEAD><BODY><P><IMG alt="SS.PNG" class="jive-image image-1" height="113" src="https://community.qlik.com/legacyfs/online/207713_SS.PNG" style="height: 112.626px; width: 759px;" width="759" /></P><P></P><P>Hi guys,</P><P></P><P>As above, I have the first 5 columns. The 6th column is how I calculate hourly efficiency. </P><P></P><P>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. </P><P></P><P>Thank you.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculating-day-average-based-on-hourly-numbers-calculation/m-p/136125#M764588 haneeshmarella 2020-11-25T16:16:04Z Re: Calculating day average based on hourly numbers calculation? https://community.qlik.com/t5/QlikView/Calculating-day-average-based-on-hourly-numbers-calculation/m-p/136126#M764589 <HTML><HEAD></HEAD><BODY><P>Hi, for get KPI in a text box try with :</P><P></P><P>avg(aggr( (Count of case#) / ((Head Count)*(Hourly Target Count of Case#)), Date YYYYMMDD))</P></BODY></HTML> Thu, 12 Jul 2018 14:42:19 GMT https://community.qlik.com/t5/QlikView/Calculating-day-average-based-on-hourly-numbers-calculation/m-p/136126#M764589 sergio0592 2018-07-12T14:42:19Z Re: Calculating day average based on hourly numbers calculation? https://community.qlik.com/t5/QlikView/Calculating-day-average-based-on-hourly-numbers-calculation/m-p/136127#M764590 <HTML><HEAD></HEAD><BODY><P>Thank you Jean. The only correction needed was to replace Date YYYYMMDD with Time HH to take an average after calculating hourly. </P></BODY></HTML> Thu, 12 Jul 2018 16:36:47 GMT https://community.qlik.com/t5/QlikView/Calculating-day-average-based-on-hourly-numbers-calculation/m-p/136127#M764590 haneeshmarella 2018-07-12T16:36:47Z