How to create calculation based on date parameter for calculating the forecasted value for rest of the month no quicksight?

Can anyone suggest a formula in quicksight if I want to get a prediction based on calculations and don’t want to use the ML power forecasting?

Hi @jcolucci ,

a very simple prediction is to use the previous value as next value. In that case you need the lag function.

I guess it should be a bit more complex. Bit more complex but still simple is the WindowAverage.

You can find a list of function here: Functions by category - Amazon QuickSight

Best regards,
Nico

1 Like

Hi @jcolucci,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

Hi @jcolucci,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!