1 Reply Latest reply on Jan 10, 2019 9:24 AM by Deepak Rai

    Combining Date Fields/Filter for Multiple Date Fields

    Beatrix Balogh

      Hi Tableau users!

       

      I have been trying to figure out how I can filter on date for multiple date columns, using only one filter. I know that Tableau allows for you to pivot columns together, but that only seems to work if I am connected to an excel document, and my actual data is coming from a SQL database.

       

      I've attached the workbook with some test data.

       

      My overall goal would be that on Sheet 1 I would have a table that shows overall:

      Active2
      Closed - Final1
      Enrolled4
      New6
      Pending Enrollment3

       

      but then I can also hone in a specific day or week or month e.g. filtering on the month of December 2018 my table would change to

      Active2
      Closed - Final1
      Enrolled1
      New1
      Pending Enrollment1

       

      Thanks in advance!