7 Replies Latest reply on Jul 11, 2017 9:30 AM by Andrew Kelley

    # of Products at a specific point in time

    Arthur Tang

      Hi Tableau Community,

       

      I have been faced with a small task and cannot figure it out. I have a large excel spreadsheet of data (6000 + rows) and would like to see how many products are "active" at any given point in time. What is provided is the number of months that a product is active and the month START date for the product's activity.

       

      For example:

       

      MONTHS IN SERVICE                                                  IN SERVICE START DATE

      45                                                                                   May-2012

      50                                                                                   April-2010

      29                                                                                  September-2011

       

       

      Is there a way to be able to figure out on tableau at a specific given month, how many products are active or do I have to add in the end date through excel?