Adding a forecast as a calcuted field

[medpere]

I want to create a calculated field with a forecast (daily volume vs. forecast).

[Xclipse]

Hello @medpere

Thanks for your question. Please take a look at the blog below.

Using value day-7 to calculate new value

Hi all, im new to this community, so thanks for your help in advance! Im trying to figure out how to create a formula/calculated field for forecasting expected passengers on busses. As per screen i have the headcount per shift going forward on daily level (headcount_revised). From another source i get the past passengers per lane, shift and day (AGT_Ist). What i want to do is to use past utilization which is AGT_Ist / headcount_revised as per 1. and create another calculated field which shoul…

[medpere]

It worked for me to apply it to a chart, but I would like to create some type of parameter or field that I can place in a visual

[Xclipse]

Try using parameters in calculated fields:

Using calculated fields with parameters in Amazon QuickSight - Amazon QuickSight