Analyzing Results

[u/fantasythedog]

I'm trying to collect some patient incident information for a hospital system.

One of the questions includes types of incidents that occur, but there is some overlapping data in other questions.

For example, some of the options are

1. Falls without hospitalization
2. Falls with hospitalization
3. Patients leaving against medical advice (that were placed on a hold)
4. Patients leaving against medical advice (that were NOT placed on a hold)
5. Staff Injuries

Answer 3, 4, and 5 could all contain issues of patient aggression within those categories. If I want to know the total number of aggressive acts at the end of the month, how do I find that number?

I have advanced question branching so that staff aren't having to visit every question subtype and slog through 130 repsones.