4 Replies Latest reply on Aug 24, 2016 3:23 AM by Andrew bilham

    Linking 2 Tableau Sheets

    Andrew bilham



      I am relatively new to Tableau so please bare with me


      I have 2 Tables in 1 data source with a common field.


      In short I have:


      Hire_Fleet table with all our vehicles




      Hire Table with all the Hires


      I need to work out utilisation, (hire days/fleet days) when I join the 2 tables it ends up double/triple counting fleet days as their are many hires per fleet car.


      I have got 2 Tableau sheets with the data..


      Hire Days Sheet - Fleet ID Rows and Hire Days Column


      Fleet Days Sheet - Fleet ID Rows and Fleet Days Column


      How do I now combine this data?


      Thank you