topic Re: Help with an expression in App Development

Help with an expression

silvacarlos — Thu, 18 Jul 2019 15:15:29 GMT

Hi guys I need your help,

I have this table

N_PURCHASE	ID_USER	ACTION
1	A	APP
1	B	GIFT
1	C	GIFT
1	D	COUPON
2	A	APP
2	B	APP
3	A	GIFT
3	B	APP

In a KPI I need to count N_PURCHASE =2 but when N_PURCHASE=1 AND ACTION = GIFT. In this case this count should results 1, only ID_USER=B

I hope you can understand this,

Thanks in advance!

Re: Help with an expression

sunny_talwar — Thu, 18 Jul 2019 17:03:11 GMT

You want a count N_PURCHASE = 2? How are you getting this?

Re: Help with an expression

silvacarlos — Thu, 18 Jul 2019 17:18:54 GMT

I want a count of Users that have N_PURCHASE = 2 but previously (N_PURCHASE =1) they have ACTION = GIFT. In the example the only user that have this conditions is user B

I hope you can understand this, if not I'll try to show another example

CS

Re: Help with an expression

sunny_talwar — Thu, 18 Jul 2019 17:29:27 GMT

May be this

Count(DISTINCT {<N_PURCHASE = {2}, ID_USER = P({<N_PURCHASE = {'1'}, ACTION = {'GIFT'}>})>} ID_USER)

Re: Help with an expression

silvacarlos — Thu, 18 Jul 2019 17:46:19 GMT

This is what I wanted!

Thank you so much Sunny as always