I downloaded and looked at the workbook on Public - the data doesn't come with it so I can't tell how you would join it to your file
I have a question - was this an example used on a blog or in a training session?
I ask because I worked on this data for another poster a couple of weeks ago
If it is a training example you might want to go to the source to see the data structure
Thanks for the message Jim. Actually I had also posted the original example using the same data under a different account (Shelley Cobb). I had to create this account after I couldn't reset the password of the other account. :/
So yes I forgot to include the other dataset since I hadn't parsed it out yet from the original review. I *was* able to parse one row of the new dataset that I want to integrate into this viz and am waiting on the rest but thought I'd see if this small sample could help you in integrating it. The field value number is how we're connecting this dataset to the original using row number. Does that make sense?
Here's a link to the incomplete dataset I'm trying to integrate. Really appreciate your help Jim.
Still looking for a solution on how to display the study data for each outcome. Here's the complete dataset with the study information for each state (outcome). As you can see, there's some repetitive info with the study info but I'm not sure how else to link it. I'd like to include all studies (Author, Title, Journal and PMID) in each bubble's tooltip but am not sure how to take this dataset and attach it to the associated bubble chart. Any help is greatly appreciated.
So I re-read your message about not being able to see the dataset in the original workbook. Not sure why it didn't come through but here's a link to the same viz with the dataset included. Hope this helps.