Forum Discussion

NB3's avatar
NB3
Helper III
7 years ago
Solved

Add trend line to line chart

Hi everyone,

 

I'm trying to add a trend line to a line chart and I can't seem to find the option ...

 

I used to do it but has the option been removed from the last update ?

 

If so what are my options to add a trend line ?

 

Thanks,

 

Nick


Need Help
  • NB3's avatar
    NB3
    7 years ago

    Nervermind I found it,

     

    I just changed my X axis (Months) from categorical to continous,

     

    Nick

3 Replies

  • NB3's avatar
    NB3
    Helper III
    7 years ago

    Nervermind I found it,

     

    I just changed my X axis (Months) from categorical to continous,

     

    Nick

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    NB3 it still exists depends wht visual and what value you are using on x-axis?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    For Line Chart, the Trend Line is available only if you have a single Y-axis (and as mentioned, the date X-axis must be continuous).

    If you have a secondary Y-axis, the trend line option is not shown.

     

    My use case is showing # of created support tickets (1st Y-axis) and # of resolved support ticket (2nd Y-axis) vs. the date (X-axis).

    So it seems that I will need to create a new line chart visual with a single Y-axis using the formula [resolved minus created] and then add the trend line.