1 Reply Latest reply on Oct 30, 2013 10:34 AM by Tracy Rodgers

    Data linked but want to display more clearly

    Darren Brownsey

      Hi,

       

      I have attached the file/s in question.

       

      There are 3 x main measures that I am trying to display together:

      • AA run times (static)
      • Scheduled Run times
      • Dwell times

       

      The AA times and scheduled times display together and are linked by Mine name.  Dwells times are linked to Scheduled Run Times by a unique Service ID. I can get the dwell times to display with the other times but the format is poor.

       

      Dwell times are categorized by codes, descriptions and attribution.  I would really like to display AA run times, scheduled run times and dwell times together but have the dwell times categories grouped in minutes but displayed in separate colours.

       

      Any suggestions for better visualizations would be great?

       

      I know this is vague but I'm new to tableau and really finding it difficult to describe what i'm trying to achieve.

       


        • 1. Re: Data linked but want to display more clearly
          Tracy Rodgers

          Hi Darren,

           

          I'm not sure I completely understand the outcome. However, upon looking at your workbook, it looks as though all the Service ID1s from the PlannedDwells data source were not matching up with the DTP & AA Times Joined. I changed the Service ID1s calculation in the Planned Dwells source to be the following and they worked better:

           

          right(Left([Service Dt],5),2) + Left([Service Dt],2)  + right([Service Dt],4) + "-"+ [First Leg Service Id]

           

          -Tracy