Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
if i write like this "avg({<psila ={'123'}>}sum_kg)
i get sum kg for feild psila=123
how do i write psila not 123 , in set analyse ?
thanks'
yarin.
Hi,
avg({<psila -={'123'}>}sum_kg)
Regards
avg({<psila -={'123'}>}sum_kg)
Hello, I have problem with set analyse. I want to filter only values, where is the rows max. I have this, but it is not good.
Sum ({<[Rank of line] = {"$(=max([Rank of line])"} >} [Sum of income]). Thanks for helping me.
Here is my table.
ID Purchase Row Income
N01 1 200
N02 1 50
N02 2 70
N02 3 60
N03 1 10
N03 2 35
N04 1 10
N04 2 40
N04 3 60
N04 4 90
N05 1 20
Set Analayse should choose me only this table.
ID Purchase Row Income
N01 1 200
N02 3 60
N03 2 35
N04 4 90
N05 1 20
Hi,
try this in script
test:
LOAD * INLINE [
ID ,Row,Income
N01,1,200
N02,1,50
N02,2,70
N02,3,60
N03,1,10
N03,2,35
N04,1,10
N04,2,40
N04,3,60
N04,4,90
N05,1,20
];
Final:
Load ID,max(Row) as maxRow Resident test group by ID;
Left join
Load ID, Row as maxRow,Income Resident test;
DROP Table test;
Regards,
You can write like this as well?
avg({<psila={'*'} - {'123'}>}sum_kg)