Report Functions
The following functions are available in the Report Details section:
- Count – Counts the number of values in a range
- CountUnique – Counts the number of unique values in a range
- Max – Returns the largest value in a set of integers
- Min – Returns the smallest number in a set of integers
- Avg – Calculates the arithmetic mean of a set of integers
- Sum – Adds all of the integer values
For example, using the following set of files, the functions yield the results below:
- For File ID: Count=6, CountUnique=6
- For EventA patient or employee related occurrence which is recorded in paper or electronic format. Once recorded, an event file is reviewed by a file manager who may involve other individuals (e.g. using tasks and follow-ups features) to help investigate and resolve the event. Type: Count=6, CountUnique=3
- For File Open Days: Count=6, CountUnique=5, Max=45, Min=4, Avg=13, Sum=79
|
File ID |
Event Type |
File Open Days |
|
1234 |
Fall |
5 |
|
1235 |
Fall |
12 |
|
1236 |
Medication Event |
5 |
|
1237 |
Fall |
4 |
|
1238 |
Adverse Drug Reaction |
45 |
|
1239 |
Fall |
8 |