7 Replies Latest reply: Dec 20, 2015 4:54 PM by Gilles Courtin RSS

    Use of count function in set analysis

    Tushar Suvarna

      Hi i have a simple table   with   productid  ,  customerid , amount

       

       

      ProductIDcustomerIDAmount
      p01h01100
      p02h02130
      p03h01100
      p04h03150

      is want a simple chart which    gives me    the list of customers who has  purchased more than 2 products  so for that i am using

      this expression

       

      if(count(DISTINCT ProductID)>1,count(distinct ProductID))

       

      and customID as my dimension  .

       

      Is there any way that i can use Set analysis  for count(productID) >1    in the expression itself as  the above method takes to long to process the data .?

       

      Thanks and regards

       

      s_tushar