13 Replies Latest reply on May 2, 2019 8:47 AM by Nagendra Ganti

    Identification of Active Customers in a Given Period

    Bradley Robinette

      Hi All,

       

      Our team is trying to create a worksheet in Tableau in which we may show the number of active customers in a given period, based on each customer's Contract Start Date and Contract End Date. We have tried several methods but have yet to come up with a solution that works.

       

      Our data set is straight forward:

       

      Tableau Help 1.PNG

       

      For example, we know that Computer Supply Company is active in February of 2019 (as well as every other month until the end of the year). Ultimately we would like each month and year on the X-Axis and would have the count of customers within each month and year.

       

      Here is an example of output we would like to see:

       

      Tableau Help 2.PNG

       

      Any ideas on how to solve this is much appreciated!