4 Replies Latest reply: Apr 12, 2018 7:54 AM by Virilo Tejedor

# Ignoring the selection in one field

Hi,

I'd like to count all users that have reached a point in the purchasing process.

The idea is to have a segmentation of users who wasn't able to overcome a step (or users that decided to leave at this step): STATE_OF_PROGRESS > 2

For me, it's important to differenciate between users that have overcome this point at least once in the past.  So I group by user and take into account their Max(STATE_OF_PROGRESS)

Count({\$<USER_ID = {"=Max(STATE_OF_PROGRESS) > 2"}>} DISTINCT USER_ID)

The problem here, is that STATE_OF_PROGRESS is a complex function depending on another STATE field.

I'd like the expression above to be indifferent to the selection in STATE.

I tryed without success:

Count({\$<USER_ID = {"=Max(STATE_OF_PROGRESS) > 2"},STATE=>} DISTINCT USER_ID)

Count({\$<USER_ID = {"=Max(STATE_OF_PROGRESS) > 2,STATE="}>} DISTINCT USER_ID)

How could I ignore the selection in one concrete field (STATE)?

Thanks in advance,

Virilo

• ###### Re: Ignoring the selection in one field

May be this

Count({\$<USER_ID = {"=Max({<STATE>}STATE_OF_PROGRESS) > 2"},STATE=>} DISTINCT USER_ID)

Or this

Count({\$<USER_ID = {"=Max({<STATE>}STATE_OF_PROGRESS) > 2"}>} DISTINCT USER_ID)

• ###### Re: Ignoring the selection in one field

Thanks a lot, Sunny!

The first one is working like a charm:

Count({\$<USER_ID = {"=Max({<STATE>}STATE_OF_PROGRESS) > 2"},STATE=>} DISTINCT USER_ID)

The other one is not working for me.

Why must I use this set modifier {<STATE>}?  What does it mean without an equal operator?

• ###### Re: Ignoring the selection in one field

Equal sign or no equal sign... it means the same thing... ignore selection

• ###### Re: Ignoring the selection in one field

Thanks again!