on 02-06-2018 7:48 PM
I need some sort of formula or something that I could add to a crosstab or possibly a running total, etc...that will give me the average number of IV lines inserted into patients per day. I have the placement date\time and the type of line. So patient A may have had 3 lines inserted while in the hospital and patient B may have had 1 and patient C had 10. I need the average of these. Thanks in advance.
Not sure what you want.
1 Average lines in a day for all patients. So in you example if that was one day the average would be 14/3 = 4.67
Or
2 Average per patient for each day So in you example if the period was 3 days
Patient A = 0.33/day
Patient B = 1/day
Patient C = 3.33/day
If 1 then just group patients by Day in group footer add this formula
@average
count(Insertions, datefield "daily")/Count(patientID, DateField, "daily")
If 2 group by patient and create a similar formula but this time counting days using Datediff() function
Ian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.