3 Replies Latest reply on Sep 9, 2018 2:42 PM by Deepak Rai

    How to create a chart from data in wide format in Tableau

    Kaleb Hauser

      Background and objective

       

      I have data that is organised as follows:

       

      OriginDestination
      Time_carTime_jetTime_heli
      LocALocX6467
      LocBLocX6678
      LocALocY4435
      LocBLocY4235

       

      In Tableau, I want to be able to plot the average of the maximum times for each `Destination` column, for each type of transport.

      So,

      • For Time_heli, the maximum time to LocX is 8 (out of 7 and 8)
      • The maximum time to LocY is 5
      • The average of those two is 6.5

      This produces something this after repeating for Time_car and Time_jet:

      USNCp.png

      I am using Tableau 10.5.4 version on Windows 8

       

      Approach

       

      To do this, I will get the maximum times for each Place by creating a new field for each type of transport with:

      {FIXED Place,Option: MAX([Time_Car])}
      {FIXED Place,Option: MAX([Time_Jet])}
      {FIXED Place,Option: MAX([Time_Heli])}
      

       

      However, this won't allow me plot the data in one chart on Tableau.

       

      How can I achieve the chart above?