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:
|YEAR||AUDIT ID||TEAM NAME||AUDIT TITLE||AUDIT START DATE||AUDIT END DATE||CLOSED ACTUAL DATE||PUBLISHED ON||AUDIT REPORT FIRST PUBLICATION||AUDIT REPORT LAST PUBLICATION||AUDIT STARTED PROPOSED DATE||AUDIT STARTED ACTUAL DATE||CLOSED PROPOSED DATE||FIELDWORK PROPOSED DATE||FIELDWORK ACTUAL DATE||REPORTING PROPOSED DATE||REPORTING ACTUAL DATE||DRAFT PROPOSED DATE||DRAFT ACTUAL DATE||FINAL PROPOSED DATE||FINAL ACTUAL DATE|
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!