1 Reply Latest reply on Jul 21, 2015 11:48 AM by Jared Grant

    can i create a calculated trend line

    G G

      In my graph i have a dual axis graph. I would like to add a trendline or a refrence line which is calculated and not directly derrived from the  2 spend and orders in the graph.  Is it possilbe?

        • 1. Re: can i create a calculated trend line
          Jared Grant

          You can't directly overlay it with spend and orders because you would need another axis for your calculated field.  You may be able to come up with some calculation that would allow you to put your calculated field for the trendline/refline on the columns shelf and have dual axes on the columns and the rows though.

           

          You may also have some luck trying a stacked bars visual with three levels, one level for your trendline/refline and two levels for your data.