1 Reply Latest reply on Apr 9, 2018 8:32 AM by Jim Dehner

    Combining different Date Dimensions

    Enrico Serafini

      Hello everyone,

       

      I'm new to Tableau and I'm trying something that might be just a little bit too hard: I need your help!

       

      I have two Date Dimensions:

      - Hiring Date

      - Leaving Date

       

      I want to compare them in the same chart, by counting the number of hires and leavers each month:

       

                               Jan     Feb ...

      Hiring               10       13

      Leaving            5          4

       

      Is it possibile to do it within Tableau through a time calculations?

      I'd like to avoid to creare seperate datasets...

       

      Thank you,

      Enrico

        • 1. Re: Combining different Date Dimensions
          Jim Dehner

          Good morning

          Yes tableau can be used to solve your problem

          The solution to your issue depends on your data structure - you have not provided a workbook but if you check out the link below you will find a comprehensive list of links on the topic of working with 2 dates

           

          FAQ:  Open & Close Dates

           

           

          Jim

           

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          1 of 1 people found this helpful