Hello I would like to have column where the difference (in days) is calculated between each End date for each ID is calculated.
Here a example of sample data ( this just an example , how to do it o it can work for various case)
| ID | End date |
| 1 | 01/02/2022 |
| 1 | 01/01/2022 |
| 2 | 18/01/2022 |
| 3 | 20/02/2022 |
| 4 | 19/01/2022 |
| 4 | 07/01/2022 |
| 4 | 03/03/2022 |
| 1 | 18/03/2022 |
| 2 | 07/01/2022 |
| 3 | 15/01/2022 |
Here a example of result I want to have
| ID | nb DAYS | End Date |
| 1 | 0 | 01/01/2022 |
| 1 | 31 | 01/02/2022 |
| 1 | 47 | 18/03/2022 |
Thanks 
