Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
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))