1 Reply Latest reply on Jan 9, 2014 8:05 AM by Matt Lutton

    Combining Time Data from different data sources

    Rohit Parmar-Mistry

      Hi I have time data of hours worked by people on different data sources now i want to combine all the workers onto one sheet. However some log it on sharepoint and others log it else where. Now if on the main sheet i use for tableau the names of everyone is on there and they have a code to show which database they are using can i create a calculated field that will pull the data from the database the code is related to ie a calculated field of some sort with an if statement?

       

      I am waiting on the guys at work to give me a license to start planning this out so it is all very theoretical at the moment but im hoping my thinking with the if statements is correct. Not sure if i have explained it very well though as my tendency is to waffle as if im thinking out loud

       

      Cheers

       

      Ro