# Why is there a limit to forecasting days in Q?

**URL:** <https://community.amazonquick.com/t/why-is-there-a-limit-to-forecasting-days-in-q/31088>\
**Category:** Q&A\
**Tags:** qls-qtopic, Business-Intelligence-Engineer, quick-sight\
**Created:** [June 8, 2024, 12:33pm UTC](https://community.amazonquick.com/t/why-is-there-a-limit-to-forecasting-days-in-q/31088 "2024-06-08T12:33:14Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pranjal](https://avatars.discourse-cdn.com/v4/letter/p/ecc23a/32.png) [@Pranjal](https://community.amazonquick.com/u/Pranjal)\
**Post date:** [June 8, 2024, 12:33pm UTC](https://community.amazonquick.com/t/why-is-there-a-limit-to-forecasting-days-in-q/31088/1 "2024-06-08T12:33:14Z")

</div>

I had added a dataset in the Q which contained data for last 6 months, however the forecast feature was only available for the next 24 days why is there a capping here

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/d/0/d04af483cd1ca746bd2949bc08dc1bc2aaca3f45.png)

---

<div class="post-metadata">

**Author:** ![Koushik\_Muthanna](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/koushik_muthanna/32/3290_2.png) [@Koushik\_Muthanna](https://community.amazonquick.com/u/Koushik_Muthanna)\
**Post date:** [June 10, 2024, 7:15am UTC](https://community.amazonquick.com/t/why-is-there-a-limit-to-forecasting-days-in-q/31088/2 "2024-06-10T07:15:06Z")

</div>

@Pranjal ,

Are you looking for a longer time period ? Can you change the granularity to Month and see if that helps ?

Kind regards,  
Koushik

---

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [June 10, 2024, 1:45pm UTC](https://community.amazonquick.com/t/why-is-there-a-limit-to-forecasting-days-in-q/31088/3 "2024-06-10T13:45:57Z")

</div>

Hi @Pranjal, we hope this solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.” (click the check box under the reply)

---

<div class="post-metadata">

**Author:** ![Pranjal](https://avatars.discourse-cdn.com/v4/letter/p/ecc23a/32.png) [@Pranjal](https://community.amazonquick.com/u/Pranjal)\
**Post date:** [June 11, 2024, 5:11am UTC](https://community.amazonquick.com/t/why-is-there-a-limit-to-forecasting-days-in-q/31088/4 "2024-06-11T05:11:27Z")

</div>

The trouble with using week or month level granularity is that the data is non additive (Money outstanding as on each day end), if i switch this to month level it adds up the data of each day end and then forecasts which is incorrect way of looking at data.

---

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [June 28, 2024, 3:48am UTC](https://community.amazonquick.com/t/why-is-there-a-limit-to-forecasting-days-in-q/31088/5 "2024-06-28T03:48:54Z")

</div>

> **[References for machine learning and RCF - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/learn-more-about-machine-learning-and-rcf.html)**
>
> To learn more about machine learning and this algorithm, we suggest the following resources:

---

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [June 28, 2024, 3:50am UTC](https://community.amazonquick.com/t/why-is-there-a-limit-to-forecasting-days-in-q/31088/6 "2024-06-28T03:50:16Z")

</div>

Also, you may want to try your own model.

> **[Integrating Amazon SageMaker models with Amazon QuickSight - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/sagemaker-integration.html)**
>
> Integrate your Amazon SageMaker models with Amazon QuickSight Enterprise edition.

---

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [June 28, 2024, 3:50am UTC](https://community.amazonquick.com/t/why-is-there-a-limit-to-forecasting-days-in-q/31088/7 "2024-06-28T03:50:45Z")

</div>