Hi all,
I have a query.....
I am trying to build a histogram that displays the count of adverse events in a group of patients, over the period of time since dosing (usually 24hrs for daily dosing) in 1hr or 30min intervals- or better still user defined! with some medical data. The idea is to see if adverse events (like vomiting) are associated with dosing and if so, what is the distribution like.
My issue is I have the time since dosing in seconds.
For each individual, I have the Individual_ID, AdverseEventType, TimeSinceDose (secs), DayOfStudy
How could I group/bin the data so that I can create this visualisation?
I'm sure its an easy solution, but being a noob, I'm finding it tricky.
Thanks in advance
Mark