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

    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