6 Replies Latest reply: Apr 4, 2017 3:43 PM by Stefan Wühl RSS

    Regression line where dimension is not value

    Max Shevchenko

      Hi,

       

      Distance:

      LOAD * INLINE [

      Country, StopPoints

      Country1, City1

      Country1, City2

      Country1, City3

      Country2, City1

      Country2, City2

      Country3, City1

      Country3, City2

      Country3, City3

      Country3, City4

      ];

       

      I need Regression line as separate field in a line chart.

      What should I change here?

      =LINEST_M(TOTAL Aggr(Count(Distinct StopPoints), Country), Country)*Country + LINEST_B(TOTAL Aggr(Count(Distinct StopPoints), Country), Country)

       

      Thx.