# How to Display Only Next Week’s Forecast Count in Quick Sight Narrative? **URL:** \ **Category:** Q&A\ **Tags:** feature-request, Business-Intelligence-Engineer, quick-sight\ **Created:** [October 7, 2025, 2:08pm UTC](https://community.amazonquick.com/t/how-to-display-only-next-week-s-forecast-count-in-quick-sight-narrative/49982 "2025-10-07T14:08:20Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Abhishek\_24](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Abhishek\_24](https://community.amazonquick.com/u/Abhishek_24)\ **Post date:** [October 7, 2025, 2:08pm UTC](https://community.amazonquick.com/t/how-to-display-only-next-week-s-forecast-count-in-quick-sight-narrative/49982/1 "2025-10-07T14:08:20Z")
Hi everyone, I’m working on a **forecast Narrative** in **AWS Quick Sight** and need some help refining the output. Here’s my current setup inside the **Edit Narrative** editor: ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/9/1/91c1a162f023db64ae126940cbd24b86e5059ff0.png) **urrent Output (Preview):** > **Total Appointments Forecasted:** 94,690.23 (Oct 5, 2025 - Oct 12, 2025) ### **What I Want to Achieve** Right now, the narrative shows the forecast period starting from **this week (Sun, Oct 5)** — but I want it to show **next week’s forecasted count only**. ✅ For example: - **This week:** Oct 5 – Oct 11 → _should not display_ - **Next week:** Oct 12 – Oct 18 → _this should display_ Basically, I want the forecast to **start from the upcoming week (future period)**, skipping the current one. What **computation or function** can I use in Quick Sight to show only **next week’s** forecast in my narrative or visual? **Example Goal:** > **Total Appointments Forecasted:** 98,245.76 _(Oct 12, 2025 – Oct 18, 2025)_ Any guidance or example expression on how to compute or restrict the forecast window to only **next week’s range** would be greatly appreciated!!.. ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [October 8, 2025, 3:20pm UTC](https://community.amazonquick.com/t/how-to-display-only-next-week-s-forecast-count-in-quick-sight-narrative/49982/2 "2025-10-08T15:20:00Z")
Hi @Abhishek_24, Looking back through old posts, I believe this is a current limitation with the forecasting tool in QuickSight. While dealing with the forecasting in a different visual type, the logic works the same [in this scenario](https://community.amazonquick.com/t/time-series-forecast-aggregation-for-a-forecasted-period/12358) I believe as it does not allow you to customize the time period; it would have to be based on your current granularity that’s set and does not allow you to pick the window within your granularity that you’d like to forecast. I’ll mark this as a feature request to promote visibility to the AWS support team. ---
**Author:** ![Abhishek\_24](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Abhishek\_24](https://community.amazonquick.com/u/Abhishek_24)\ **Post date:** [October 8, 2025, 3:35pm UTC](https://community.amazonquick.com/t/how-to-display-only-next-week-s-forecast-count-in-quick-sight-narrative/49982/3 "2025-10-08T15:35:20Z")
I’d really appreciate your help with this as well. I’m using the **Forecast Insight** computation in QuickSight to predict future values. When I set the **time field to “Day”** and choose a **period of 30** , I’m getting **negative forecast values**. But when I switch the time field to **“Week”** and set the **period to 4** (which is roughly the same as 30 days), the forecast is **positive and looks accurate**. Why is there such a big difference in results between the daily and weekly forecast, even though the total duration is almost the same? Is there something about how QuickSight calculates forecasts at different time grains that causes this variation? ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [October 13, 2025, 5:46pm UTC](https://community.amazonquick.com/t/how-to-display-only-next-week-s-forecast-count-in-quick-sight-narrative/49982/4 "2025-10-13T17:46:56Z")
Hi @Abhishek_24, I assume that it has something to do with how their algorithm handles the value options within the time granularity; I can’t say for certain though as AWS does not disclose full information on how they’ve designed their forecasting tools. This documentation provides the best background information that I can locate regarding Quick’s ML forecasting features: > [@Introduction to Amazon Quick Sight ML Insights](https://community.amazonquick.com/t/introduction-to-amazon-quicksight-ml-insights/4029): > > [Amazon Quick Sight](https://quicksight.aws/) was launched in November 2016 as a fast, cloud-powered business analytics service to build visualizations, perform ad hoc analysis, and quickly get business insights from a variety of data sources. In 2018, ML Insights for Quick Sight (Enterprise Edition) was announced to add machine learning (ML)-powered forecasting and anomaly detection with a few clicks. These insights are automatically generated as suggested insights, and you can also add custom insights to your analysis. …