Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
Missing Group By clause may be?
Avg should need Group By. Without that it won't work for aggregate functions like Sum, Avg, Count ... in script
Hi Agrim,
Avg need group by
for example:
table:
load
field_1,
if(((Avg([Rating #])))='1', 'a', if(((Avg([Rating #])))=2, 'b')) as classification
from table.xls
group by field_1;