topic LINEST_R2 Straight Table in Insight Advisor https://community.qlik.com/t5/Insight-Advisor/LINEST-R2-Straight-Table/m-p/1881512#M87 <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> Mon, 17 Jan 2022 03:47:42 GMT EDehzn 2022-01-17T03:47:42Z LINEST_R2 Straight Table https://community.qlik.com/t5/Insight-Advisor/LINEST-R2-Straight-Table/m-p/1881512#M87 <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> Mon, 17 Jan 2022 03:47:42 GMT https://community.qlik.com/t5/Insight-Advisor/LINEST-R2-Straight-Table/m-p/1881512#M87 EDehzn 2022-01-17T03:47:42Z