Qlik Community

Insight Advisor

Discussions about Insight Advisor in Qlik Sense®

Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

LINEST_R2 Straight Table


I am trying to find the R2 values for each customer in form of straight table. I am using this expression currently

=LINEST_R2(TOTAL AGGR(SUM(Amount),Month),Month)

to get R2 value for each customer where the x-axis is total amount and y-axis is Month.


However the straight table  shows the same R2 for all customers.


How can I calculate R2 values for each customers?

0 Replies