avg aggr count load editor equivalent

[ioannagr]

This is my  in-app script

avg(aggr(count(ID)), date)

But how can I do it in data load editor?

I'm assuming like

Load avg(count(ID))

resident Table

group by date;

Please correct this if it's wrong

thank you in advance

[sunny_talwar]

May be this if you are looking to calculate the Avg across the board (meaning this was shown in a text box object)

LOAD Avg(ID_Count);
LOAD Date,
Count(ID) as ID_Count
Resident ...
Group By Date;