Hi
In Quicksight
Im using a line chart visual with a 6 month forecast set up for sales based on value: sales value and X axis date of sales aggregated by month
From this I have also been given 2 insights which I use a forecast and month over month change
When I created these initially it was the end of the month and the data forecast looked good.
However now its the start of the month the forecasts all fall dramatically as it looks like its using Novembers data as a full month even though we've only 6 days data. The line chart dips dramatically in the forecast section.
How can I fix this so the reports either discount an incomplete month or determine the values taking the percentage of the days in month where there's data into account?
The forecast period is 6 forward, changing it or the backwards value doesnt improve the report.
The only time it looks ok is towards the end of the month, bizarre these reports dont take the percentage of the current period into account when calculating forecasts- so I must be overlooking something
