https://community.qlik.com/t5/QlikView/Linest-R2/m-p/1882554#M1216910 <P>Hi,</P> <P>I am trying to find the R2 values for each customer in form of straight table. I am using this expression currently</P> <P>=LINEST_R2(TOTAL AGGR(SUM(Amount),Month),Month)</P> <P>to get R2 value for each customer where the x-axis is total amount and y-axis is Month.</P> <P>&nbsp;</P> <P>However the straight table&nbsp; shows the same R2 for all customers.</P> <P>&nbsp;</P> <P>How can I calculate R2 values for each customers?</P> Wed, 19 Jan 2022 01:46:32 GMT EDehzn 2022-01-19T01:46:32Z https://community.qlik.com/t5/QlikView/Linest-R2/m-p/1882554#M1216910 <P>Hi,</P> <P>I am trying to find the R2 values for each customer in form of straight table. I am using this expression currently</P> <P>=LINEST_R2(TOTAL AGGR(SUM(Amount),Month),Month)</P> <P>to get R2 value for each customer where the x-axis is total amount and y-axis is Month.</P> <P>&nbsp;</P> <P>However the straight table&nbsp; shows the same R2 for all customers.</P> <P>&nbsp;</P> <P>How can I calculate R2 values for each customers?</P> Wed, 19 Jan 2022 01:46:32 GMT https://community.qlik.com/t5/QlikView/Linest-R2/m-p/1882554#M1216910 EDehzn 2022-01-19T01:46:32Z