April 23, 2012 at 4:09 pm
I’ve received an unusual but very practical request for a graph that will depict how long a given patient has been on a specific medication in terms of start and stop dates. Also, a common circumstance is that a given medication will be stopped and then restarted for a client at a later date.
In other words, I need to graph multiple date ranges on a single row for a single drug.
I've attached a spreadsheet containg sample data and graph that will hopefully help make this all clear.
I'm very comfortable modifying the data (query wise) in any way to help facilitate what I am trying to do.
Whatever suggestions you may have regarding chart types, techniques, etc. would be very appreciated.
April 24, 2012 at 7:05 am
I think a line is probably your best bet with the drug as your series and date on the X axis. Lines will break when there is no data for example when a drug is not used during a measurement period. I would probably also assign a random integer (1, 2, 3) to each drug and make that your Y axis so the lines don't overlap
April 24, 2012 at 10:33 am
Daniel, thank you very much. This is exactly the kind of advice I was looking. I might even be able to make my boss happy 🙂
April 24, 2012 at 11:53 am
I have not tried this before but you might be able to make the drug both the Y axis and the series eliminating the need for the integer. Not sure, I would have to test it and fiddle around a bit.
April 24, 2012 at 3:02 pm
The interesting experience I'm having is that it is graphing from StartDate to StartDate instead of StartDate to EndDate. I may have to rewrite my query to fool it into thinking that an end date is a subsequent start date.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply