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

Question & Answer
, ,
1

For a month there is total cost till date and based on selection of the parameter for current date calculation should give us the forecasted value for rest of the month.

In tableau I used following calculation, Please help me to convert it in AWS Quicksight Calculations.

(([Total Cost])/7 ) * (DAY(DATETRUNC(‘month’,(DATEADD(‘month’,1,[Date Selection])))-1)-DAY([Date Selection]))

2

@Mayur1, QuickSight offers ML-powered forecasting, you can forecast your key business metrics with point-and-click simplicity. please review the details and use it generate forecast for your use case.

3

Can anyone suggest if I want to get forecast based on the calculations and don’t want to use ML power forecasting?