i want to calculate the following scenario...
i want to group by id and calculate average of amount at script level.
LOAD id,sum(amount) as sumamount,
avg(amount) as avgamount
(ooxml, embedded labels, table is Sheet1) Group by id;
utsav u can do it in ui level very easily ....
Juast by takinmg your id as dimention ..
hi try this
LOAD * INLINE [
Group by id;
hope it helps
Aggr function works for that
Retrieving data ...