Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have my data as shown below.
ID | Date |
111 | 6/1/2023 |
111 | 6/2/2023 |
111 | 6/3/2023 |
123 | 6/3/2023 |
156 | 6/11/2023 |
156 | 6/12/2023 |
846 | 5/14/2023 |
846 | 5/14/2023 |
846 | 5/15/2023 |
846 | 5/16/2023 |
846 | 5/17/2023 |
I need to create an End Date and also find average number of days between Date and End Date per ID
ID | Date | End Date | Average Days |
111 | 6/1/2023 | 6/3/2023 | |
123 | 6/3/2023 | 6/3/2023 | |
156 | 6/11/2023 | 6/12/2023 | |
846 | 5/14/2023 | 5/17/2023 |
Looks like a direct duplicate of https://community.qlik.com/t5/New-to-Qlik-Sense/Create-End-Date-per-ID-and-also-find-Average-days-be...