16 Replies Latest reply: Dec 14, 2016 4:56 PM by Sinan Ozdemir RSS

    How to show recent a 3 months regression line in a 12 months bar chart

    bill yu

      How to set up a regression line or trend line show the recent 3 months in a 12 months bar chart?

       

      In particular, below graph show me all possible 12 months, but I only want to take show 3 months trend line? What is the possible solution?

       

      linest_m(total aggr(if(sum([Cash_Payments]),sum([Cash_Payments])),Month),Month)*              

      +linest_b(total aggr(if(sum([Cash_Payments]),sum([Cash_Payments])),Month),Month)

       

      I tried changing only({3}Month, but the regression won't show up anymore if it changes. Please help.

       

       

      Capture1.GIF