Qlik Community

Insight Advisor

Discussions about Insight Advisor in Qlik Sense®

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

LINEST_R2 Straight Table

Hi,

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