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 Qrvey.
Can you provide more context around Qrvey as the question isn’t clear.
1 Like
We are trying to achieve, 1st visit date of patients through formula or transformation in qrvey, on the basis of these fields, Patient_ID, Date of Visit.
@Abhishek_24 can you please tell what is Qrvey ?
Possibly a calculated field using minOver - Amazon QuickSight should help
Kind regards,
Koushik
2 Likes
Hi @Abhishek_24 - I agree with @Koushik_Muthanna @sakkamzn , If you can provide sample input and expected output, that will help in providing the right solution. Anyway, please try the suggestion from @Koushik_Muthanna and let us know whether it will resolve your problem or not.
Regards - Sanjeeb
1 Like