Please help me to calculate LiNest_R2 calculation at country level, needs to add total aggrigation.
Please help me to calculate LiNest_R2 value in bar graphe.
we have a scatterplot chart it is showing dimenssion as Country and calculating 2 measures with Linear r2. this R2 value should match with bargraph Linest_r2 value. in bargraph Dimention as 5 measures that defined as in inline which is Dimention, but data is customer level need to add country level calculation for LiNest_r2.
LiNest_R2(total Aggr(Measure 1, Measure 2),Country) this aggrigation is not working in Qlik bargraph(Below mentioned ppt chart due to data security)