2 Replies Latest reply on Dec 5, 2017 6:55 AM by Peng Chen

    Passing variables from one data source to another

    Peng Chen

      Hi dear community,

      Would you pls help me on this case?

      I have 2 data source,

      • Data source 1 stores a version with name and start and end date
      versionstartend
      a11/09/201720/12/2017
      b21/12/201703/02/2018
      c06/02/201807/05/2018

       

      • Data source 2 store people's holiday

       

      Namedateholiday
      aaa11/10/20171
      aaa11/12/20170.5
      ...

       

      I wish to calculate each person's actual working day = (workday between start and end in version table) - sum(holiday field in holiday table who's date is between the selected version's start and end date)

       

      I have attached the tableau sheet here. Pls let me know if this is doable in tableau or not, if not, I might create a script to generate this date in the database.

       

      Thanks  a lot for helping!