Hello,
I am wondering if it's possible to create a JSL column formula to calculate the number of days between the observation of an ID WITHIN the same DATE column (e.g. "By ID, Calculate elapsed days By DATE"). The output would evaluate the appearance(s) of the same ID and calculate the elapsed time between each appearance of the same ID. This is not a column A to column B comparison, this is a Within column A evaluation (within same column).
Note, the First observation of any ID will be blank because there is no comparison (first observation). After First observation, the calculations would function 1st vs. 2nd ... 2nd vs 3rd ... and so on.
Below is a draft concept. Thank you for any help.
| ID | DATE | ELAPSED_DAYS |
| ABC123 | 1/1/2021 | |
| ABC123 | 10/31/2021 | 303 |
| ABC123 | 6/30/2023 | 607 |
| EFG567 | 6/30/2021 | |
| EFG567 | 10/31/2021 | 123 |
| XYZ901 | 5/31/2021 | |
