Forecasting Explanation

Jasper Dan Estareja shared this question 2 months ago
Answered

Hi Support,


Can you provide a detailed explanation on how the figures are calculated in a Moving Average forecasting? I found this on the wiki page, but I don't think this would be enough for our client.

/f296a462f766ecf7e951bdc8d120816d

We have this report configured with Trending Variable set to Auto. Our client is really keen to know how Yellowfin exactly comes up with the data on their report.

/b8abcb357a5ab26ed7e4b44ba7abedb4


Below is a screenshot of their report with dummy data.

/358c0a62443aabac786c66bbabf04bae


Thanks,


Jasper

Comments (3)

photo
1

Hi Jasper,

Thanks for reaching out.

Unfortunately, I couldn't find any other documentation related to moving average in yellowfin. Moving average is basically averaging the data points based on the period (please refer to article1 and article2)

I believe, the moving average period if not selected manually(left in auto), then it would select a number depending on the data set. For example: I have 12 periods(2012-2023) in my data, when I left it in auto it spanned for 4years.


/c77045310857e11e308cea7b29ac363e


We can manually change the periods as outlined in the wiki article to a desired number. I hope that helps.

Best Regards,

Deepak

photo
1

Hi Deepak,


Thanks for this, I'll forward these articles to our client.

You may close this ticket now, I'll reach out again if they still have further questions.


Thanks,

Jasper

photo
1

Hi Jasper,

Thanks for the update.

I will go ahead and mark this as answered.

Best Regards,

Deepak