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

posta 6 mesi fa77 visualizzazioni
Nessuna risposta

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande