🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

find two consecutive dates

AbbasZavar22

Hi there,

I have a data set of patients with their lab test results (+ the date of test).

Each patient may have several lab tests. I want to find the latest date of lab test (abnormal one) and the exact previous one (based on the date) for each patient.

Any recommendation on how I can get the latest date and the previous one (two consecutive dates)

Find more posts tagged with

AI Studio

Accepted answers

All comments

MartinLiebig

Hi,

I would group into collection by patient id use loop collection, sort by time and use Filter Example Range to take the last 2.

BR,

Martin

BalazsBaranyRM

Hi!

This will work as long as the last lab test is the last entry by customer. If not, you could use Aggregate to get the date of the latest positive lab test, self-join with this entry, and use Generate Attributes (e. g. the date_diff() function) to determine if the entries are later. These can be filtered out with Filter Examples.

Regards,
Balázs

AbbasZavar22

mschmitz

Could you please provide me with more explanation, step by step with the name of the operators?
Thanks a lot in advance