Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;