Lastvalue table function attribute error

Question

I have multiple records (history records) per opportunity and I need to get the last value for the last load date. My calculations looks as follows: lastValue({total_contract_value},[{load_date} ASC],[{opportunity_id} ASC])
I have both load date and opportunity_id in my field wells but it still says table calculation attribute  references are missing from field wells. Any advice? 
![Enter image description here](/media/postImages/original/IMBU8IYf09S2OMHq3Veeznpg)

Answer

Hello,

The first argument in the lastValue function should be an aggregated measure to display the data on the Visual. Aggregate function is required to return a single value for the partition fields.

Please refer the AWS QuickSight document on the same: https://docs.aws.amazon.com/quicksight/latest/user/lastValue-function.html

Please modify your calculated field like below, it can be any aggregate function like sum, max etc. on the required field:

lastValue({sum(total_contract_value)},[{load_date} ASC],[{opportunity_id}])

Thanks.

Lastvalue table function attribute error

Relevant content