topic Approximation of Hourly Census in QlikView https://community.qlik.com/t5/QlikView/Approximation-of-Hourly-Census/m-p/133259#M510175 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to approximate a 24 hourly census in a bar chart using the following expression:</P><P></P><P>=Round(avg(aggr(Sum(CensusIn),CensusHour,VisitDate))</P><P>+ avg(aggr(sum(EDTime),CensusHour,VisitDate))/2 </P><P>- avg(aggr(sum(CensusOut),CensusHour,VisitDate)))</P><P></P><P>Its a pretty good approximation, but if I filter on a specific day, it quite a bit off.</P><P>Any ideas?</P><P></P><P>Thanks,&nbsp;&nbsp; Jonathan</P></BODY></HTML> Mon, 13 Aug 2018 12:46:37 GMT Anonymous 2018-08-13T12:46:37Z Approximation of Hourly Census https://community.qlik.com/t5/QlikView/Approximation-of-Hourly-Census/m-p/133259#M510175 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to approximate a 24 hourly census in a bar chart using the following expression:</P><P></P><P>=Round(avg(aggr(Sum(CensusIn),CensusHour,VisitDate))</P><P>+ avg(aggr(sum(EDTime),CensusHour,VisitDate))/2 </P><P>- avg(aggr(sum(CensusOut),CensusHour,VisitDate)))</P><P></P><P>Its a pretty good approximation, but if I filter on a specific day, it quite a bit off.</P><P>Any ideas?</P><P></P><P>Thanks,&nbsp;&nbsp; Jonathan</P></BODY></HTML> Mon, 13 Aug 2018 12:46:37 GMT https://community.qlik.com/t5/QlikView/Approximation-of-Hourly-Census/m-p/133259#M510175 Anonymous 2018-08-13T12:46:37Z