topic Re: count the transactions against each admin and avg transaction per admin in App Development https://community.qlik.com/t5/App-Development/count-the-transactions-against-each-admin-and-avg-transaction/m-p/1910808#M75062 <LI-CODE lang="markup">=Avg(Aggr(Count(Transactions),Admin))</LI-CODE> <P>&nbsp;</P> <P>hope this helps</P> <P>Marco</P> Mon, 28 Mar 2022 19:07:40 GMT MarcoWedel 2022-03-28T19:07:40Z count the transactions against each admin and avg transaction per admin https://community.qlik.com/t5/App-Development/count-the-transactions-against-each-admin-and-avg-transaction/m-p/1910672#M75046 <P>Hi</P> <P>I have data like this</P> <TABLE width="147"> <TBODY> <TR> <TD width="64">Admin</TD> <TD width="83">Transactions</TD> </TR> <TR> <TD>A</TD> <TD>T1</TD> </TR> <TR> <TD>B</TD> <TD>T2</TD> </TR> <TR> <TD>C</TD> <TD>T3</TD> </TR> <TR> <TD>D</TD> <TD>T4</TD> </TR> <TR> <TD>A</TD> <TD>T5</TD> </TR> <TR> <TD>D</TD> <TD>T6</TD> </TR> <TR> <TD>B</TD> <TD>T7</TD> </TR> <TR> <TD>C</TD> <TD>T8</TD> </TR> <TR> <TD>D</TD> <TD>T9</TD> </TR> <TR> <TD>C</TD> <TD>T10</TD> </TR> <TR> <TD>A</TD> <TD>T11</TD> </TR> <TR> <TD>B</TD> <TD>T12</TD> </TR> <TR> <TD>B</TD> <TD>T13</TD> </TR> <TR> <TD>A</TD> <TD>T14</TD> </TR> <TR> <TD>A&nbsp;</TD> <TD>T15</TD> </TR> <TR> <TD>A</TD> <TD>T16</TD> </TR> <TR> <TD>B</TD> <TD>T17</TD> </TR> <TR> <TD>B</TD> <TD>T18</TD> </TR> </TBODY> </TABLE> <P>on this data I made a pivot like below</P> <P>Row Labels&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Count of Transactions</P> <TABLE width="233"> <TBODY> <TR> <TD>A</TD> <TD>6</TD> </TR> <TR> <TD>B</TD> <TD>6</TD> </TR> <TR> <TD>C</TD> <TD>3</TD> </TR> <TR> <TD>D</TD> <TD>3</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Now I want avg of transaction per admin, how to do that using expression</P> Mon, 28 Mar 2022 14:34:10 GMT https://community.qlik.com/t5/App-Development/count-the-transactions-against-each-admin-and-avg-transaction/m-p/1910672#M75046 deeavhad 2022-03-28T14:34:10Z Re: count the transactions against each admin and avg transaction per admin https://community.qlik.com/t5/App-Development/count-the-transactions-against-each-admin-and-avg-transaction/m-p/1910711#M75049 <P>Hi</P> <P>Do you want like this?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MayilVahanan_0-1648480389576.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/75510i7629870AAC56B084/image-size/medium?v=v2&amp;px=400" role="button" title="MayilVahanan_0-1648480389576.png" alt="MayilVahanan_0-1648480389576.png" /></span></P> <P>&nbsp;</P> Mon, 28 Mar 2022 15:13:16 GMT https://community.qlik.com/t5/App-Development/count-the-transactions-against-each-admin-and-avg-transaction/m-p/1910711#M75049 MayilVahanan 2022-03-28T15:13:16Z Re: count the transactions against each admin and avg transaction per admin https://community.qlik.com/t5/App-Development/count-the-transactions-against-each-admin-and-avg-transaction/m-p/1910808#M75062 <LI-CODE lang="markup">=Avg(Aggr(Count(Transactions),Admin))</LI-CODE> <P>&nbsp;</P> <P>hope this helps</P> <P>Marco</P> Mon, 28 Mar 2022 19:07:40 GMT https://community.qlik.com/t5/App-Development/count-the-transactions-against-each-admin-and-avg-transaction/m-p/1910808#M75062 MarcoWedel 2022-03-28T19:07:40Z