@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.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| How to bring a substring associated with the minimum date and time? | 2 | 733 | June 9, 2022 | |
| Calculating if it is the first occurrence of an event | 2 | 1351 | 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 | 4 | 282 | May 26, 2023 | |
| Umm! does anyone knows, how this can achieved in Qrvey? | 5 | 199 | June 12, 2023 | |
| How to extract records with a specific value if that is the latest record within the give timeframe | 2 | 360 | February 28, 2023 |