I am working on a dashboard, where I have to display the timelines for multiple dates.
| Relase | In ST(Start Date) | In ST(End Date) | In RT(Start Date) | In RT(End Date) | In ET(Start Date) | In ET(End Date) |
| 22.1 | ||||||
| 22.2 | 03/01/2022 | 20/01/2022 | 25/01/2022 | 02/02/2022 | 03/02/2022 | 11/02/2022 |
| 22.3 | 24/01/2022 | 10/02/2022 | 16/02/2022 | 23/02/2022 | 24/02/2022 | 04/03/2022 |
| 22.4 | 16/02/2022 | 03/03/2022 | 08/03/2022 | 16/03/2022 | 17/03/2022 | 03/03/2022 |
The dates are as above, I managed display the timeline for 2 dates but when I am incorporating multiple dates, the dashboard gets distorted this is what I want.
This is what I have implemented.
This is my search.
| rename "PR_Go_Live" as In_PR "In_ST_Start Date" as ST_Start_Date "In_ST_End Date" as ST_End_Date "In_ST_End Date" as RT_End_Date
| eval start = strptime(ST_Start_Date, "%d/%m/%Y")
| eval end = strptime(In_PR, "%d/%m/%Y")
| eval duration = (end - start) * 1000
| stats count by start ST_End_Date ST_End_Date duration Release
| table start Release ST_End_Date duration
