jshumakerFrequent Visitor3 years agoSolvedlinestx I am confused how the LINESTX function works within a group. The first screen shot is of a matrix showing that there is only 1 k1 record for any given l0 group. The second screen shot is of a matri...Show Moretamerj13 years agoHi jshumaker please try r2_fk01 =VAR l =LINESTX ( 'fk01 mx', [max pct], [k1] )RETURNAVERAGEX ( l, [CoefficientOfDetermination] )
tamerj13 years agoHi jshumaker please try r2_fk01 =VAR l =LINESTX ( 'fk01 mx', [max pct], [k1] )RETURNAVERAGEX ( l, [CoefficientOfDetermination] )
tamerj13 years agoHi jshumaker please try r2_fk01 =VAR l =LINESTX ( 'fk01 mx', [max pct], [k1] )RETURNAVERAGEX ( l, [CoefficientOfDetermination] )
tamerj1Community Champion3 years agoHi jshumaker please try r2_fk01 =VAR l =LINESTX ( 'fk01 mx', [max pct], [k1] )RETURNAVERAGEX ( l, [CoefficientOfDetermination] )
Related contentLINESTX with slicerLINESTX multiple categoriesCannot find [Slope1] in using LinestxLINESTX - not able to see the intercept and slope valuesUnable to reference LINESTX table output using SELECTCOLUMN
