Variables in data load editor

[Prink]

Hi,

I have created a variable in script. And I'm trying to use that variable in a where condition. I'm unable to get the result value from that variable.

let vd = 'max("Business Date")';
check:
load "Business Date",Sum(Usage)
Resident source
where "Business Date" = '$(vd)'
group by "Business Date";

I tried $(vd) and also '$(vd)'. Both are not working. I couldnt get the max date assigned in where condition.

Kindly provide me correct syntax.

Thanks !!

[Vegar]

If you want it to be dependent on the user selections you can't implement the logic in the script, you will need to do it in  the expression inside your charts and graphs.

Load your data without aggregations and where clauses and use this expression.

=SUM({<[Business Date]= {'$(=maxstring([Business Date]))'}>}Usage)