Is there a function in SQL that does the same as the excel forecast.ets function

Question

question

tryingToGetItDone asked Dec 9, '22

Is there a function in SQL that does the same as the excel forecast.ets function

I have been asked to do forecasting in SQL as previously it has been done in Excel using the forecast.ets function in Excel.

What I need to do is forecast the members count in the coming months based on historical member numbers.

Is there a SQL function that can do this?

sqlquery

1670381485006.png (78.4 KiB)

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2022-12-10T12:25:45Z

anthony.green answered Dec 10, '22

There is no SQL function to do this.

You will need to write the code yourself in T-SQL to do it or potentially look at python scripts and python statistical forecasting functions or even use R to do it instead.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question