1 Reply Latest reply on Sep 17, 2015 3:27 PM by diego.medrano

    get count of default values that does not exists in the current data

    Karthik Venkatraman



      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.


      can anyone help me with this?