I am working on a lab collection data. The data will consist of a patient, datetime and a time point. The time point is predefined from -30 mins to 24 hr and each patient can have these timepoint. sometimes the data might not be collected at a timepoint and it will not exist for that patient.
I need to get the count of such left timepoints and need to show them as a bar chart for each patient.
I have a lookup table that holds the standard default values of the timepoint. I need to compare the patient timepoints with this default timepoint and if the patients timepoint is not in the standard timepoint and vice versa, i need to count them.
Thank you for providing a sample data set! Although, I'm having some trouble understanding exactly what you're trying to accomplish. Could you provide some more clarity? Examples would be useful as well.