How do I plot a estimated average line

[dimaliens1]

Hi all,

I'm currently creating a dashboard that tracks the total amount of device upgrades over a set period of time.

The data table is being updated monthly with the new months of upgrades devices.

So far I've plotted:

- The actual amount of devices upgrade by month (in blue).

- A burndown line of the average amount of upgrades to meet the deadline (dashed).

I now want to plot a line of estimated upgrades needed to meet the deadline of end of date range from the current month. Below is an example in red of the line.

How do I go about doing this? Thanks in advance!

[lbendlin]

Have you tried enabling the forecast insight for your line chart visual?