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

    Linking 2 Tableau Sheets

    Andrew bilham

      Hi,

       

      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

       

      Then

       

      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