2 Replies Latest reply on Aug 1, 2013 5:50 AM by Ertan ERISIK

    distinct transaction numbers per customer

    Ertan ERISIK

      Hi all,

       

      This is probably an easy one but I just couldn't figure out how to resolve it. I have transactional data and I would like to see number of distinct transactions per customers. a distinct transaction means a combination of date-store-transaction_id, being date in day level. In sql this could be written as select customer_id,count(distinct  date||store_id||transaction_id) from tx_table group by 1;. I could easily add month to this sql so that I could have number of transactions per customer per month. I tried to do a similar thing in Tableau by creating a combined field using above fields, but couldn't succeed.

       

      Below is simplified version of my data. My question is, how can I achieve this with Tableau?

       

      datecustomer_idstore_idtr_idline
      01.01.20135111
      01.01.20135112
      01.01.20135113
      01.01.20135211
      01.01.20135212
      01.01.201310121
      01.01.201310122
      02.01.20135111
      02.01.20135112
      02.01.201310121

       

      I appreciate any guidance.

       

      Best regards,