Do you need all that past history? What decisions/message do you want people to take away from the viz?
In addition to Alex's question. Maybe another question would be how many patients are on a particular drug at a given time?
The past history is extremely relevant. Knowing prior treatments relates to "line of therapy". For example, if a patient was prescribed an initial regimen that failed they would then begin their "2nd line of therapy".
From a marketing perspective understanding which formulations, dose, etc. patients were prescribed previously and the duration of those treatments provides valuable info.
It is also relatively easy for me to determine how many patients are on a particular drug by using a cross-tab.
I have been attempting to develop an accurate way of demonstrating regimen duration. Certain users recommend datediff while many others suggest a boolean operation. So far, nothing has proven to be the final solution.
The information in the graphic above seems accurate but not that simple to quickly review!?
1 of 1 people found this helpful
I would definitely go for a single Gantt with duration as length. Getting that length depends on your data structure - are your end dates on the same row as your begin dates for a particular dose?. Do the dose lengths ever overlap? If so, maybe you could use transparency.