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.
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
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