cancel
Showing results for 
Search instead for 
Did you mean: 

Only pull patients that have more than one value

cothmer
Participant
0 Kudos

I have a report that looks at discharge orders. Some patients may have more than one order. I only want to see those patients on my report. Right now I have the field in my details section so it pulls all of the orders. I do see some duplicates but I am also getting the all of the data I need to see. How do I only see those patients with more than one order ?

Accepted Solutions (0)

Answers (2)

Answers (2)

cothmer
Participant
0 Kudos

i guess I am not sure what you mean. the report currently groups on patient_id.

when I select group from select expert, what am I grouping on ? the formula ?

in the formula what am I counting ? the name of the order, the date of the order, or the order_id ?

DellSC
Active Contributor
0 Kudos

Try this:

1. Group by Patient.

2. Go to Report >> Select Expert >> Group (or click on the down arrow next to the Select Expert button and select Group.)

3. Your formula will look something like this:

Count({MyTable.OrderNumber}, {Patient Group Field}) > 1

This will filter out all patients that only have one discharge order and only show those that have more than one.

-Dell