Help with an expression

[silvacarlos]

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!

CS

[sunny_talwar]

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

[silvacarlos]

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

[sunny_talwar · Accepted solution]

May be this

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

[silvacarlos]

This is what I wanted!

Thank you so much Sunny as always

CS