I have a patient id named in patient_id in one column and their date of visits name date_visited in another column, I need to add an calculated field for 1st visit date of every patient in Quicksight

Question & Answer
1

Hi
I have a patient id named in patient_id in one column and their date of visits name date_visited in another column, I need to add an calculated field for 1st visit date of every patient in Quicksight.

2

This should do the trick:

minOver(date_visited, [patient_id], PRE_FILTER)

Let me know if this works for you, thanks!

1 Like
3

Thankyou so much. It worked. Is there any chance or medium where i can direct ask for your help?

4

You can feel free to send me a direct message by clicking on my profile.

It looks like the QuickSight Team is having a live Q&A, which you may be interested in checking out!

1 Like
5

@MKuhns01 patient that had a visit after not having a visit for X days) What transformation can work for this. Idea is to get the count of patient. We have Date_Visited column, Patient_ID.