Add trend line to line chart

[NB3]

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

[Anonymous]

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.

[parry2k]

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

[NB3 · Accepted solution]

Nervermind I found it,

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

Nick