topic avg(aggr(sum( in set anaylsis in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/avg-aggr-sum-in-set-anaylsis/m-p/1664930#M4851 <P>hi,</P><P>whats wrong with this script? it's not working</P><P>please help me</P><P>avg(Aggr(Sum({$&lt;[Date.autoCalendar.YearMonth]={"2019-Sep"}&gt;}[Traffic In])))</P><P>&nbsp;</P><P>&nbsp;</P><P>thank you</P> Fri, 10 Dec 2021 20:29:42 GMT chan103148 2021-12-10T20:29:42Z avg(aggr(sum( in set anaylsis https://community.qlik.com/t5/Connectivity-Data-Prep/avg-aggr-sum-in-set-anaylsis/m-p/1664930#M4851 <P>hi,</P><P>whats wrong with this script? it's not working</P><P>please help me</P><P>avg(Aggr(Sum({$&lt;[Date.autoCalendar.YearMonth]={"2019-Sep"}&gt;}[Traffic In])))</P><P>&nbsp;</P><P>&nbsp;</P><P>thank you</P> Fri, 10 Dec 2021 20:29:42 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/avg-aggr-sum-in-set-anaylsis/m-p/1664930#M4851 chan103148 2021-12-10T20:29:42Z Re: avg(aggr(sum( in set anaylsis https://community.qlik.com/t5/Connectivity-Data-Prep/avg-aggr-sum-in-set-anaylsis/m-p/1664933#M4852 <P>Hi,</P><P>You missing the dimension on your Aggr funtion.</P><P>avg(Aggr(Sum({$&lt;[Date.autoCalendar.YearMonth]={"2019-Sep"}&gt;}[Traffic In]), <EM><STRONG>DimensionForYourAggr</STRONG></EM>))</P><P><SPAN>Best Regards.</SPAN></P><P><SPAN>Goncalo Pereira</SPAN></P> Mon, 13 Jan 2020 08:52:03 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/avg-aggr-sum-in-set-anaylsis/m-p/1664933#M4852 goncalo_ricardo_pereira 2020-01-13T08:52:03Z