4 Replies Latest reply on May 8, 2018 11:46 PM by Elie Rahi

    Calculation for Missing Values

    Elie Rahi

      I need a row-by-row calculation. I've attached data showing duration times for each type of person. However those that "Checked out session end" = 1 then estimate the duration by the median duration.

       

      For example the median duration for parents is 0.7 hour; This would be the estimated duration for parents with checked out session end = 1. So I'm thinking something like this:

       

      IF Checked out session end = 1 AND Visitor = Parents THEN median(Duration)

      ELSEIF Checked out session end = 1 AND Visitor = Patients THEN median(Duration)

      etc...

       

      Something is not working out for me