I am facing many different issues with Forecasting in quicksight.
Within forecasting with line graphs:
- You are unable to utilize a dynamic end point as a ‘date to forecast to’
- if a forecast errors, can we prefer to just disable the forecast but still render the graphic? or overlay an error on the graph and disable the forecasting?
within insight narrative forecasting:
- again you cannot use a custom end date. This is causing such a headache. In order to forecast a final number for a end of month forecast, I resort to forecasting 1-31 days, for every possible day in the month, then I have a calculated field that gives me the ‘days to end of month’ and whatever day that matches, it forecasts the appropriate number of days. As you can imagine this becomes extremely difficult to manage (you have 31 if statements on the same line that render base on how many days until the end of the month)
- utilizing the forecastmetric.metricValue.value vs forecastmetric.metricValue.Formattedvalue, is very annoying. You cannot us a formatted value field for calculations then display the value in the formatted value again. Is it possible to get a function like formatDate, but formatCurrency within quicksight or narriative editor?
- The editor is actually extremely broken. Highlighting does not work properly, you cannot tell where your cursor goes when you try to move it around manually with arrow keys on a keyboard. Worst of all sometimes copy pasting works, some times it doesnt, sometimes it slices right though for or if statements breaking everything all together. Extremely frustrating to use.