Hello Experts,
We used the group by in the script as,
AAgg:
load
Key,
sum(counter) as AAgg.#_of_records
resident U
group by Key;
and the front end expression is like below,
sum(aggr(if(sum([AAgg.#_of_records])=0,1,0),E.Group))
Since the aggregation on the scripting side consumes a long time to reload, I want to remove the group by clause in the backend and need to do the calculation on the front end using set analysis.
Can you please suggest the best approach for this.
Thanks