https://community.qlik.com/t5/QlikView/Create-an-average-based-on-2-dimensions/m-p/1689641#M725765 <P>Hello everyone</P><P>I want to be able to get the average of calls coming in a call center based on 2 dimensions (hour of the day and day of the week). This would technically give me a 24x7 grid.</P><P>So far, I've only been able to represent a total for each hour/day combination, but not an average...</P><P>Can anyone provide some insights on 1) if that can be done and 2) how should I do it?</P><P>Thanks for your help!</P><P>Nic</P> Wed, 25 Nov 2020 16:16:04 GMT nicalbert 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Create-an-average-based-on-2-dimensions/m-p/1689641#M725765 <P>Hello everyone</P><P>I want to be able to get the average of calls coming in a call center based on 2 dimensions (hour of the day and day of the week). This would technically give me a 24x7 grid.</P><P>So far, I've only been able to represent a total for each hour/day combination, but not an average...</P><P>Can anyone provide some insights on 1) if that can be done and 2) how should I do it?</P><P>Thanks for your help!</P><P>Nic</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Create-an-average-based-on-2-dimensions/m-p/1689641#M725765 nicalbert 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Create-an-average-based-on-2-dimensions/m-p/1689666#M725766 <P>Use a pivot table with avg as aggregation and tick Show Partial Sums for both dimensions. In analyse mode pivot your table</P> Wed, 01 Apr 2020 01:23:18 GMT https://community.qlik.com/t5/QlikView/Create-an-average-based-on-2-dimensions/m-p/1689666#M725766 Lisa_P 2020-04-01T01:23:18Z