2 Replies Latest reply: Jun 10, 2013 12:50 PM by Jihan Wang RSS

    Results of Set Analysis using {1} does not match select all

    Jihan Wang

      Hi,

       

      I am using Set Analysis to calculate mortality rate. For example, if the patient status is 01 (patient died), then add it to the numerator. The numerator will then be divided by the total patients admitted to the hospital.

       

      I plan to add a grand average line (similar to the center line in the control chart), which is the grand rate across all age,gender,etc. To prevent the center line change with the field selection(date range, gender). I use the following expression:

       

      sum({1} if (ptstatus='01',1,0))/count({1}patient)

       

      However, the result of the above expression is different from not using set analysis by having all the fields selected.

       

      Do you know what would be the cause and how to get the correct grand average.

       

      Thanks a lot!