3 Replies Latest reply: Oct 16, 2014 2:39 AM by Joey Stekkinger RSS

    Expression with Count over a count.

    Joey Stekkinger

      Dear community.

      As a designer i would like to build a text object that shows me the number of customers (field called Klant_UniqueID, which shows e-mailadresses of a customer) that had more than one transaction (field called Transactie_Transactienummer which generates a unique number for each transaction).

       

      If I build a table and use Klant_UniqueID as a dimension and as expression:

      =COUNT(DISTINCT Transactie_Transactienummer)

      i get the amount of transactions per customer. But now I want to know how many customers had MORE than 1 transaction, shown in 1 single textobject.


      Does anyone have a suggestion? I appreciate your help