Re: How do i do this expression in the load script
In which context (e.g. chart dimensions) are you using this expression?
If you want to do aggregations in the script, you'll need a GROUP BY clause and use aggregation functions on all fields not listed in that clause. You can filter records in an additional WHERE clause or use conditional functions within the aggregation functions.