topic Re: Max and aggregate in App Development

Max and aggregate

phongnnguyen — Mon, 08 Oct 2018 09:15:31 GMT

Hi all,

I want to calculate max of sum like example below

date	ID	Sticker	Amount
1	T1	A	100
1	T1	B	200
1	T1	C	300
2	T1	A	200
2	T1	B	100
2	T1	C	400
1	T2	D	2
1	T2	E	3
1	T2	F	5
2	T2	D	8
2	T2	E	7
2	T2	F	1

I want the result is :T1 = 200+100+400=700

T2=8+7+1=16

this means Sum Amount based on each date, and choose Max number for each ID T.

ID	Amount
T1	700
T2	15

I used to a set analysis: max(aggr(sum(Amount),Date))

But it doesnt work

YoussefBelloum — Mon, 08 Oct 2018 09:21:26 GMT

Hi,

for T1, if you need max(amount) for each date, it will be:

T1= 300 (for date 1) + 400 (for date 2) = 700

for T2:

T2= 5 (for date 1) + 8 (for date 2) = 13

niclaz79 — Mon, 08 Oct 2018 09:31:04 GMT

Hi, this works for me:

Max(Aggr(Sum(Amount),date, ID))

YoussefBelloum — Mon, 08 Oct 2018 09:42:54 GMT

try this expression:

=sum(aggr(max(Amount),ID,date))

phongnnguyen — Mon, 08 Oct 2018 09:45:53 GMT

It is right, awesome. Thanks so much

niclaz79 — Mon, 08 Oct 2018 09:51:11 GMT

Do you mind marking it as correct?

date	ID	Sticker	Amount
1	T1	A	100
1	T1	B	200
1	T1	C	300
2	T1	A	200
2	T1	B	100
2	T1	C	400
1	T2	D	2
1	T2	E	3
1	T2	F	5
2	T2	D	8
2	T2	E	7
2	T2	F	1

date	ID	Sticker	Amount
1	T1	A	100
1	T1	B	200
1	T1	C	300
2	T1	A	200
2	T1	B	100
2	T1	C	400
1	T2	D	2
1	T2	E	3
1	T2	F	5
2	T2	D	8
2	T2	E	7
2	T2	F	1

date	ID	Sticker	Amount
1	T1	A	100
1	T1	B	200
1	T1	C	300
2	T1	A	200
2	T1	B	100
2	T1	C	400
1	T2	D	2
1	T2	E	3
1	T2	F	5
2	T2	D	8
2	T2	E	7
2	T2	F	1