I have the data as below (#1) in a table currently, where the Segment date is expected to be displayed as shown in table (#2). From the sample data given below, the application is approved four times, then denied, then approved and again denied for a particular period.
The segment date is expected to be displayed as
For approvals -'Min of Approved date' to 'previous date of Denial'
For denials- 'Min of Denied date' to 'previous date of Approval'
As an application id could be approved and denied several times, request your help in calculating the 'Segmented Interval' field for multiple approvals and denials respectively. how to identify whether the application was approved for the first time or second time to calculate respective interval