Aggregation and result problem

aminehaddar — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have this table : (exemple )

SEGMENT	ID	LIMITE_CIBLAGE	LIMITE_AOUT	CLIENTS_CIBLAGE	NBR_CLIENT	TX
			4		1	25,000%
X	63794	2000,0	2000,0	1	0	0,000%
X	69064	2000,0	2000,0	1	0	0,000%
X	75092	2000,0	2000,0	1	0	0,000%
X	87401	0,0	33.5	1	1	100,000%
....

NBR_CLIENT=if(LIMITE_AOUT<>LIMITE_CIBLAGE, 1,0)

I have 5 segments, if I choose the first one, I got 0.001%, or my expresion is NBR_CLIENT/CLIENTS_CIBLAGE should give me 2.1%

I tried for the others, it is the same problem, or for the SEGMENT = X , I got the right result.

For segment Y for exemple: I have NBR_CLIENT=1600 and CLIENT_CIBLAGE = 5700.

I can't find what is the problem. any help please?

thanks.

Re: Aggregation and result problem

ogautier62 — Mon, 10 Sep 2018 11:29:18 GMT

Hi,

with something like sum(nbr_client)/sum(total <segment> clients_ciblage) it should be better

regards