AnsweredAssumed Answered

Survey data analysis

Question asked by HeatherCook on Apr 14, 2014
Latest reply on Apr 14, 2014 by philmodjunk


Survey data analysis



     I have a dataset that has a similar format to the below:

     Hospital        PatientID        Diagnosis       Needed Medication     

     A                          2                   Sepsis                     Yes

     A                         5                    Influenza                  Yes

     B                         12                  Cough                      No

     C                          22                Influenza                  Yes

     The actual data set has about 3000 pts, 50 hospitals and 150 variables to report on.

     I need to generate individual summary reports for each hospital using counts of catagorical data (Yes/No).  I need to then take the number of 'Yes' counts (numerator) and divide by the number of patients in that hospital (denominator) to report a percent. 

     I can easily do the calculation in my stats program, but would prefer to use Filemaker since it can generate visually pleasing reports.

     I'm pretty sure these calculations are not difficult in Filemaker, but since I'm under a deadline I thought I would post to the forum to ask about the syntax.


     Thanks for your assistance,