7 Replies Latest reply: Jul 17, 2014 6:11 AM by Lander Uriarte RSS

    AVERAGE BY MAXIMUM VALUE

    Lander Uriarte

      Hi there!

       

      I'm a bit lost , so i hope someone of you will give me light about the question below.

       

      I got this example to explain the logic:

       

      CENTRE IDPATIENT IDMESSURE ORDER TEMPERATURE
      A10138,4
      A11137,4
      B21139,2
      B22137,5
      B22236,6
      A10238,2
      A11237,3
      B21238,6
      B21337,4
      A10337
      A11336,2
      B21436,8
      A10436,6

       

      I need to know the (average of temperature by (maximum messure order by patient ID)).

       

      I don´t wanna need to show the "Patient ID' field in the result which should be something like this:

       

       

      CENTRETEMP. AVG
      A36,4
      B36,7

       

       

      Regards,

       

      Lan