firstsortvalue not allowing static chart

[sifatnabil]

Hi, I have this expression in a chart:

sum( {<MONTH=,MonthNew=,WEEK=,WeekNew=} Aggr(FirstSortedValue (COMPLETED_AMOUNT,-Id),uniquetradeid,ORDER_ID))

I've tried to put in all the date fields as above to prevent date selections from changing the chart, but it's not working. This is only occurring with firstsortvalue. Thanks.

[Gysbert_Wassenaar · Accepted solution]

Add them in a set modifier for the firstsortedvalue function too.

sum( {<MONTH=,MonthNew=,WEEK=,WeekNew=>} Aggr(FirstSortedValue ({<MONTH=,MonthNew=,WEEK=,WeekNew=>}COMPLETED_AMOUNT,-Id),uniquetradeid,ORDER_ID))