Cases have many statuses in our CRM. We use statusdate which at the end of every day records the status each case was in. The thing is that it doesn’t really update it, it just records it. So a case which has been in the CRM for a year has a years worth of statusdate, with a corresponding status. W…

@HarveyB-B you can use min function , similarly minover function.

Get first recorded date for each case

DeepakS February 26, 2024, 9:45pm 2

@HarveyB-B, you can use a rank function to get the first occurrence of you application id status date, please refer this community post and let us know if this resolves your use case - Calculating if it is the first occurrence of an event.

Topic		Replies	Views
How to bring a substring associated with the minimum date and time? Q&A analysis , date , database , data-preparation , calculations	2	740	June 9, 2022
Trying to Create an Earliest Date Calculated Field Q&A analysis , calculations , Business-Intelligence-Engineer	2	35	November 29, 2025
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 Q&A calculations	4	286	May 26, 2023
Umm! does anyone knows, how this can achieved in Qrvey? Q&A calculations	5	208	June 12, 2023
Calculating if it is the first occurrence of an event Q&A analysis , calculations	2	1371	May 13, 2022