topic Count Total across a Group in QlikView https://community.qlik.com/t5/QlikView/Count-Total-across-a-Group/m-p/604226#M223261 <HTML><HEAD></HEAD><BODY><P><BR />Hi everyone,</P><P></P><P>I'm a noobie, and I have an issue that I can't seem to resolve after more hours spent than I'd like to admit.&nbsp; I have a situation in my chart (</P><P># Transactions - Rolling Count vs Day Comparison ) where I'm trying to take an average count across a date range and compare that to a single day for trending.&nbsp; To better explain I want an average count of transactions for the first two weeks of the month vs the count for the last day of the month, but across a time drill through group year, month, day, hour.&nbsp; Right now it looks ok at the month level, but as soon as I drill down it shows the overall total, because that's what I'm asking for but I need to show the average transactions for those hours and not the total.</P><P></P><P>I'd appreciate any help or suggestions as I'm truly stuck at this point!</P><P>Matt</P></BODY></HTML> Fri, 04 Apr 2014 14:59:35 GMT 2014-04-04T14:59:35Z Count Total across a Group https://community.qlik.com/t5/QlikView/Count-Total-across-a-Group/m-p/604226#M223261 <HTML><HEAD></HEAD><BODY><P><BR />Hi everyone,</P><P></P><P>I'm a noobie, and I have an issue that I can't seem to resolve after more hours spent than I'd like to admit.&nbsp; I have a situation in my chart (</P><P># Transactions - Rolling Count vs Day Comparison ) where I'm trying to take an average count across a date range and compare that to a single day for trending.&nbsp; To better explain I want an average count of transactions for the first two weeks of the month vs the count for the last day of the month, but across a time drill through group year, month, day, hour.&nbsp; Right now it looks ok at the month level, but as soon as I drill down it shows the overall total, because that's what I'm asking for but I need to show the average transactions for those hours and not the total.</P><P></P><P>I'd appreciate any help or suggestions as I'm truly stuck at this point!</P><P>Matt</P></BODY></HTML> Fri, 04 Apr 2014 14:59:35 GMT https://community.qlik.com/t5/QlikView/Count-Total-across-a-Group/m-p/604226#M223261 2014-04-04T14:59:35Z