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	731	June 9, 2022
Calculating if it is the first occurrence of an event Q&A analysis , calculations	2	1335	May 13, 2022
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	280	May 26, 2023
Umm! does anyone knows, how this can achieved in Qrvey? Q&A calculations , how-to	5	199	June 12, 2023
Function to get the minimum date filtering with 3 columns Q&A calculations , Business-Intelligence-Engineer	4	23	September 9, 2024