Is there a function in SQL that does the same as the Excel 'forecast.ets' function [closed]
Want to improve this question? Update the question so it focuses on one problem only by editing this post.
开发者_StackOverflow中文版Closed 13 hours ago.
This post was edited and submitted for review 11 hours ago.
Improve this questionI have been asked to do forecasting in SQL as previously it has been done in Excel using the forecast.ets
function in Excel.
Using exponential smoothing methodology I need to forward forecast member numbers for 3 months based on historical member numbers.
Is there a SQL function that can do this?
I have tried using the Predict() function but am getting a error and it does not seem to work:
SELECT d.*, p.Score
FROM PREDICT(MODEL = @model
DATA = MemberData AS d) WITH (Score FLOAT) AS p;
精彩评论