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.

       

      Context:

      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:

       

      =If(   

          aggr(    

              count(                

                              Visit_Id

              ),

              Year,Cust_Id,...

          )     = 0,

         

          Cust_Id

      )

       

      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.