2 Replies Latest reply on Oct 25, 2016 10:22 PM by Bowen CAI

    How can I get the conversion rate?

    Bowen CAI

      Dear All,

       

      Currently, I am learning Tableau Software, but I have difficulty to get the conversion rate. The scenario is like this, a e-commerce company has a customer and an order database. In the customer DB, it has two field (customerID and register date), and orderID, customerID and OrderDate are stored at Order DB. A registered customer may not be necessary to make an order. So I want to create a dashboard to know how many customer registered in different year according. Apart from that, I also want to know how many present of registered customer who made an order in that particular year. The sample workbook is attached below.

       

      Thanks a lot.

      Bowen