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
... View more