开发者

Is there a function in SQL that does the same as the Excel 'forecast.ets' function [closed]

Closed. This question needs to be more focused. It is not currently accepting answers.

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 question

I 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;
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜