26 Replies Latest reply: Mar 20, 2017 7:06 AM by Sunny Talwar RSS

    Set Analysis, non-visited customers (table)

    Ramzi Manoubi

      I've been spending quiet some time now trying to figure this out. Any help is welcome and very much appreciated.



      CRM, there are customers, there are visits.


      I would like to have a list with all customers for which there are no visits registered.

      I created a table with only measures as columns, except one.

      For the dimension column I use following formula:








          )     = 0,





      In this column I show the Customer Id, but only when the count of visits = 0.



      This seems to work in some cases, but is giving me a hard time when I filter.


      Thank you for your time.