From this reference Forecast Window - #2 by Xclipse regarding Quicksight forecast, it tells that the M/L algorithm will consider the last 365 days data irrespective of the filter I use on my visual but the moment I put the filter for current year in my visual, the forecasted values at weekly level changes. So, it seems like that the algorithm does consider year filter and when I put current year filter, it only consider the current year data point and forecasted values change.
Could you please confirm if it is the case. Also, If someone has successfully implemented YTD forecast at weekly level (aggregated one ) and not the individual forecast. I would need this to have a successful idea of the year end results of my metrics.
According to this article, the system uses a built in algorithm referred to as the ‘Random Cut Forest Algorithm’ to handle the forecasting trends. But there is not much documentation that explains the algorithm more in depth to explore how it’s handling time frames.
In regards to setting up on a weekly level, you should be able to change your date field to a ‘weekly’ interval, which will provide you with a weekly forecast instead of daily:
In regards to overall forecasting; while this feature is not shareable quite yet, have you explored the Scenarios option? This allows you to run more complex what if’s in a forecasting nature.
Hi Brett,
Thanks for the reply, I did set it up at weekly level and explored the What if scenario in the analysis as well. However I wanted to ask if it could tell the overall 2025 result for the end of year. For e.g I have a metric X for which I have the data for last 2 years, when I aggregate it at weekly level as you suggested, it does give me the projections for the coming weeks individually but I am interested in knowing if it is possible to have the overall year end forecasted number. When I try to aggregate it at yearly level, it says that there are just not enough data points.
I don’t believe there’s a good work around option currently to get the forecast modeling to operate in that way. I’ll mark this as a feature request to promote visibility to the support team.
Thanks Brett, I really appreciate it. A comprehensive year-end forecasting feature would be immensely valuable for customer service teams. While current Excel workarounds exist, having this functionality natively in Quick Sight would provide:
Streamlined performance projection
Enhanced strategic planning
Easier goal tracking for larger audiences.
Appreciate your support in highlighting this to the development team.
