Optimizing scripting calculations

[deep2021]

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

[vinieme12]

try below

Count({<counter={'0'}>}Distinct Total <E.Group> Key)