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

preguntada hace 6 meses77 visualizaciones
No hay respuestas

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas