4 Replies Latest reply: Mar 28, 2017 5:49 AM by Heiko Schmidt RSS

    Adding 2 different trend lines

    Heiko Schmidt

      Hello, i use a function to show a trend line :

      linest_b (

                total aggr(

                    Sum(Expression1),

                     [Month]

                 ),

                 [Month]

            )

      +

        Month *           

            linest_m (

                total aggr(

                    Sum(Expression1),

                     [Month]

                 ),

                 [Month]

            )

       

      This one calculates the trend line for all available months.

      Is it possible to show a second trend line in the same diagramm that only shows the trend for the past 6 months and a third one that shows the trend line for past 3 months to 3 months in advance.

      Best regards

      Heiko