Can anyone quickly fix my expression in the attached qvf file?
The measure is sum(aggr(max(gain_total),membership_id)), and I need to add 'as of date' filter, to sum all the points up to the selected date. I added {<Date={"<=$(=max(Date))"}>} in the expression.
Not every membership_id has a record for each date. For example member 12039393 has points up to 2019/12/03, points 4200.
However, when 2019/12/04 is selected, that member with points 4200 is not left out and returned 0.
I expect 4200 is also returned and summed.
Thanks for your help.