Quicksight Forecast Start of the month lowers enture forecast

0

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

asked 6 months ago70 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions