0 Replies Latest reply on Jan 31, 2020 7:51 AM by Akilesh Karunanidhi

    Multiple Reference Lines Based On Date Range In Gantt Chart

    Akilesh Karunanidhi

      Hello Tableau Gurus,

       

      I'm working on developing a Gantt Chart and I was able to accomplish the requirements for the most part. However, I'm struggling with a piece that I guess is a bit tricky. I work for Internal Audit and the timelines for Audit also work in the same way as the Projects timelines. However I have two Groups of Audits - Regular & BAU (Let's call it Business As Usual for simplicity sake).

       

      The intention of the of the tricky piece is to find if there are any BAU dependencies that come alongside the duration of the Regular Projects. Here is how our Data is structured for the Regular Audits:

                        

      YEARAUDIT IDTEAM NAMEAUDIT TITLEAUDIT START DATEAUDIT END DATECLOSED ACTUAL DATEPUBLISHED ONAUDIT REPORT FIRST PUBLICATIONAUDIT REPORT LAST PUBLICATIONAUDIT STARTED PROPOSED DATEAUDIT STARTED ACTUAL DATECLOSED PROPOSED DATEFIELDWORK PROPOSED DATEFIELDWORK ACTUAL DATEREPORTING PROPOSED DATEREPORTING ACTUAL DATEDRAFT PROPOSED DATEDRAFT ACTUAL DATEFINAL PROPOSED DATEFINAL ACTUAL DATE
      2019AUD-0000003102TEAM-1REG-ABC-103/18/201903/29/201904/16/201903/29/201904/03/201903/18/201903/18/201903/29/201904/03/2019
      2019AUD-0000002618TEAM-2REG-ABC-201/01/201912/31/201901/01/201901/01/201910/31/2019
      2019AUD-0000002830TEAM-3REG-ABC-304/15/201910/08/201910/08/201910/08/201904/15/201907/15/201905/22/201907/31/201907/08/201907/15/2019
      2019AUD-0000002803TEAM-4REG-ABC-406/17/201909/17/201906/17/201906/17/201909/17/201909/05/2019
      2019AUD-0000002809TEAM-3REG-ABC-502/04/201904/30/201904/30/201904/30/201910/01/201902/04/201902/04/201904/30/201904/01/201904/01/201905/08/2019
      2019AUD-0000003041TEAM-2REG-ABC-602/01/201901/31/202002/01/201901/31/2020
      2019AUD-0000002817TEAM-7REG-ABC-702/01/201901/31/202002/01/201901/31/2020
      2019BAU-0000000001TEAM-3MRA-ABC-802/11/201902/10/202005/10/201910/11/201902/14/201902/14/201905/10/201904/11/201904/11/201907/18/201905/18/2019
      2019BAU-0000000002TEAM-2MRA-ABC-902/21/201902/20/202005/20/201910/21/201902/24/201902/24/201905/20/201904/21/201904/21/201907/25/201905/28/2019

       

      The last two rows (for BAU) highlighted are custom created and we can be pretty flexible in changing to the format that we want (Infact this is a different data-source altogether). I was able to PIVOT the ROWS INTO COLUMNS for the REGULAR AUDITS and create something like this below:

       

       

       

      Now, I'm interested in the dependencies that these BAU AUDITS would create for the REGULAR AUDITS. We would like to represent them as vertical lines across the sheet or anything else fancier that suits my current design.

       

      We are even happy with just the values of "AUDIT START DATE" field for BAU AUDIT being able to represent in the view. At this point, I'm not clear if I should be using them as reference lines or place the "AUDIT START DATE" as a dimension on to the pills separately or on to the Marks card or a calculated field.

       

      Below is what we would like to have for now:

       

       

      I hope this makes sense. It would be very helpful if someone is able to assist on this. I haven't uploaded the workbook since the data is confidential. However if needed I'll get rid of the confidential data and then upload it.

       

      Thank you for your time!