I was wondering if it is possible to create a projection line per date on a graph? For example, we have computers that need to be updated, eg 200 in the next 5 days, so we would have a line that reduces by 40 computers per day? That way at the end of the 5 days we have the projection and the actual amount?

This depends on which data source you are using. Graphite, InfluxDB and Prometheus all have support for Holt Winters and other functions like linear regression. Grafana’s time range can also be changed to a future date.

Thank you for the response. I have had a look and it seems to be on the right sort of lines but the function seems to be used for data that already exists in prometheus.

The idea that I am looking for is for a future projection, eg, in two days time we are looking to have 20 machines left to update so we have two lines ones for the amount we are actually at and a line for where we want to be.

I have attached an image, I am looking to make the yellow line.

Using promql, getting a projection line with predict_linear seems to be very difficult. I have a somewhat steadily increasing value that resets at the end of the month, and hopes of getting a simple linear regression.
For some reason, predict_linear gives results that look very non-linear.
Any tips on this?