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