6 Replies Latest reply: Mar 15, 2017 12:26 PM by Marco Barroso RSS

    Excluding ranges from linest_m() + linest_b()

    Marco Barroso

      Liner Trend expression:


      linest_m(total aggr(if(sum(PaidAmount),sum(PaidAmount)),DateOfService),DateOfService)*MonthOfService


      linest_b(total aggr(if(sum(PaidAmount),sum(PaidAmount)),DateOfService),DateOfService)


      I need to exclude the last three months from the linear trend only. How can this be done ? I've tried set analysis after the aggr function, but may be doing something wrong.


      See attached example: 2017-01,2017-02, 2017-03.