Ignoring the selection in one field

[virilo_tejedor]

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

[sunny_talwar · Accepted solution]

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)

[virilo_tejedor]

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?

[sunny_talwar]

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

[virilo_tejedor]

Thanks again!