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