How to get lowest pain score in the 1st 3 days of admission

[cognos74]

Hi,

I have a report with patient details like:
last name, first name, ID, admit date and discharge date pain level

pain level score will be 1 to  7.  I have to get lowest score in the 1st 3 days of admission.
any ideas please how to get this

[Corrigon]

Can you clarify something for me? When you say "I have to get the lowest score in the 1st 3 days of admission", what exactly are you trying to achieve?

The patient with the lowest pain score overall in the first three days of admission? Or;
the lowest pain score per patient in the first three days of admission? Or;
Something else?

Also, in your question you only mention "discharge date pain level", but you also say you are trying to get the "lowest score in the 1st 3 days of admission". So is there another value for Admit Date pain level? Or just the Discharge Date Pain Level?

Cheers,
Dave

[cognos74]

Hi Thanks you.

I need to get  "the lowest pain score for each(per) patient in the first three days of admission"

Discharge date and pain level 2 different columns.

last name, first name, ID, admit date, discharge date and pain level

[Corrigon]

Ok, so I'm still unclear about how the data is structured. How many rows per patient are there? One for each day they were admitted? I'm just confused as it seems like you only have access to the Pain Level on the Discharge Date.

Regardless, it sounds like you will need to use a minimum filter. Drag the Pain Level data item into the Detail Filter section of your query.

Code Select Expand

[Pain_Level] = minimum([Pain_Level] for [ID])

This will give you the lowest pain level for each patient ID (Which I'm assuming is unique per patient.

I'm still not sure how to calculate the Pain level for the first 3 days. It seems like you only have the Discharge Date Pain level value to work with. If my Admit Date is 15 August, and my Discharge Date is 21 August with a Pain level of 4, how could you possibly determine what the lowest value in the first 3 days was if you don't have the Pain Value for each day? That's got me stumped.

[cognos74]

Hi pain level record each day from admission.

last name   first name   ID   admit date   discharge       pain recorded date/time           pain level
john                   smith  01  08/01/16      null               8/01/16  9.00 am                  4
john                   smith  01  08/01/16      null               8/01/16   7.00 pm                 3

john                   smith  01  08/01/16      null               8/02/16  5.00 am                   5
john                   smith  01  08/01/16      null               8/02/16  8.00 pm                   1

john                   smith  01  08/01/16      null               8/03/16  7.00 am                   2
john                   smith  01  08/01/16      null               8/03/16  8.00 pm                   7

john                   smith  01  08/01/16      null               8/04/16  5.00 am                   8
john                   smith  01  08/01/16      null               8/04/16  4.00 pm                   2

in above example lowest pain score in admitted 1st days is 1.  I need to get that 1.

[hespora]

I don't have example data to build and test this, but:

1. you need to identify your first three days of admission. something like

Code Select Expand


if ( [pain recorded date] < _add_days ([admit date],3) )
then ('Y')
else ('N')
let's call this [first3]

2. find the minimum

Code Select Expand


minimum( [pain level] for [id],[first3] )

let's call this [minimum]; this will actually find both the minimum for the first 3 days, and for the remainder of the stay. we will discard the latter.

3. create a subquery to your query. in that, filter on [first3]='Y', and return [id] and [minimum]