Hey Tableau Community,
I work for a clinical trials network, and I'm trying to construct a timeline for each of our active protocols that includes the date of each milestone completed. You can think of a milestone as an event within the development of our clinical trials. I tried to follow the instructions found at this website: Timeline Chart in Tableau - AbsentData; however, as you can see in the first screenshot attached, an issue arises when I choose multiple types of milestones/events in my filter (protocol milestone Id). The goal is to get the multiple milestones I choose to align themselves on each protocol's timeline. Interestingly, if you look at the second screenshot, when I only choose one milestone from the "Protocol Milestone Id" filter, I get correct dates corresponding to their correct locations on the timeline. But this is no help because I need to see multiple milestones on each timeline.
The way the data is organized is that each "event", properly called a protocol milestone, has four dates associated with it: The actual start date, actual end date, target start date, and target end date (consider these targets as anticipated or hoped for. I used the Protocol Milestone Target End Date. Instead of using protocol milestone names, use the dimension Protocol Milestone Id, which is just the number form of the name.
I would greatly appreciate if you all could help me find a solution to my dilemma. Attached is a packaged workbook in Tableau version 2019.2. Three data sources are attached. When linking across them, use the Dimension "protocol", but all the data you need should be in the protocol_milestones_tst database.
Message was edited by: joanna Peng I just replaced the Tableau workbook in the attachments section so that the data bases are extracted. I also tried changing the date pill from exact to year, and the same issue arose: when I added more than one Protocol Milestone Id to my filter, issues came up. Hope you can help me find a solution1 Many thanks, Joanna