Hello,
I have searched the usage of trend-lines with linest functions. but I do not understand very well how to use these functions.
here is what I need
I have a table with dates and vmware cluster consumption defined as vm_remaining and already deployed vms as vm_deployed. if vm_remaining = 0 the cluster is closed I I have to buy more ESX
the vm_remaining value have fluctuations because vms do not consume same resources every day
what I need is to have a projection of the trend line to the date where the cluster will be full as a graph or as a kpi I have no preference
ex:
| date | vm_remaining | vm_deployed |
| 10/02/2021 00:00 | 10 | 1 |
| 11/02/2021 00:00 | 9 | 2 |
| 12/02/2021 00:00 | 5 | 3 |
| 13/02/2021 00:00 | 4 | 3 |
| 13/02/2021 01:00 | 3 | 3 |
| 13/02/2021 02:00 | 5 | 4 |
| 13/02/2021 03:00 | 4 | 5 |
the information I need is the date when the vm_remaining will be zero
thanks for you help
