First time poster here. I am putting together a dashboard to show progress of a number of projects which all contain a given set of milestones. I put together two charts, a 'milestone overview' which shows a count of project_id by milestone achieved (blue) or not yet achieved (grey), and a 'gantt chart' which shows timeline of these milestones for each project_id see milestone and gantt dashboard. All projects should contain all of the milestones but it's not always the case.
I would now like to apply dashboard action to filter the 'gantt chart' and only show projects which contain the selected milestone in the 'milestone overview' and where that milestone has been achieved (or not achieved depending on the selection), but preserve the appearance. Esentially I need to pass project_id from 'milestone overview' to the 'gantt chart', see desired result filtered gantt
Currently, the only common dimension is activity_id (milestone) so when I use this to filter the gantt, the correct projects are shown, but all other milestones are excluded from the view and the gantt breaks see this image I've tried adding project_id to the details shelf in the 'milestone overview' chart but it then fragments the chart see fragmanted milestone chart I then tried pushing it to the secondary axis (to sit behind the aggregated chart) but dashboard actions ignore it because then only to aggregated chart from first axis can be selected. I also posted un Tableau community forums here with a sample workbook, but haven't yet had any responses. Any suggestions?
Thanks
