1 Reply Latest reply on Apr 4, 2018 4:27 PM by Wesley Magee

    I need some ideas about how to present data in tableau compared to what they did in excel

    Justin Pulley

      Excelsample.PNG

       

      So the background data on this looks like the following:

      Building
      Anticipated Start DatePlanned Completion DatePlanned 50% Design CompletePlanned 50% Design DurationPlanned 80% Design CompletePlanned 80% Design DurationPlanned 100% Design Complete

      Planned 100% Design Duration

      Actual 50% Design CompleteActual 80% Design CompleteActual 100% Design Complete
      11/1/201810/1/20181/30/2018202/28/2018203/28/2018201/27/20182/28/20183/28/2018
      22/1/201811/1/20183/2/2018203/30/2018204/27/2018203/1/20183/29/20184/27/2018
      32/15/201811/15/20183/16/2018204/13/2018205/11/2018203/16/20184/13/20185/11/2018
      43/1/201812/1/20183/29/2018204/26/2018205/24/2018203/30/20184/25/20185/24/2018
      54/1/20181/1/20194/27/2018205/25/2018206/25/2018204/26/20185/25/20186/22/2018
      64/1/20181/1/20194/27/2018205/25/2018206/25/2018205/1/20185/23/20186/27/2018
      74/20/20181/20/20195/18/2018206/18/2018207/17/2018205/17/20186/20/20187/17/2018
      85/1/20182/1/20195/30/2018206/27/201820

      7/26/2018

      205/30/20186/27/20187/26/2018
      98/1/20185/1/20198/29/2018209/27/20182010/26/2018208/29/20189/27/201810/30/2018
      109/1/20186/1/201910/1/20182010/30/20182011/29/20182010/5/201811/2/201812/4/2018

       

      All the Duration pieces are in working days

       

      Now in the excel image above the blue green colored bars are the start and duration of the planned phases, the grey line is the entire process, the other colors are other planned dates for different parts of the process (I have start and duration in days for these too), and the black horizontal line is the actual complete duration from 50% to 100% design.  I don't remember what the vertical lines are, but if it were going to be anything it would be a line for today's date if I were doing it in Tableau.

       

      I need some ideas about how to make something like this in tableau given that I don't truly have start and end dates, nor is the data in a really good format for doing this.  They want me to be able to replicate that graph, but I can't think of any possible way to do that in tableau.