I have a data set representing daily run jobs. I want to display the data to show the start time, how long each stage runs, the lag time between each stage, and the final end time.
This is a sample of the data I am working with:
ClientName | DeploymentDate | Start Time | Lag Start to Stage 1 | Stage 1 Duration | Lag Stage 1 to Stage 2 | Stage 2 Duration | Lag Stage 2 to Stage 3 | Stage 3 Duration | Lage Stage 3 to Stage 4 | Stage 4 Duration | Lag Stage 4 to End Time | End Time |
Client A | 1/7/2023 | 1/7/2023 5:07 | 0.05 | 0.02 | 0.02 | 0.15 | 0.04 | 0.03 | 0.03 | 0.05 | 0.01 | 1/7/2023 10:11 |
Client A | 1/8/2023 | 1/8/2023 7:13 | 0.02 | 0.02 | 0.03 | 0.14 | 0.04 | 0.05 | 0.02 | 0.06 | 0.01 | 1/8/2023 10:09 |
And this is an example of what the requstor is hoping to see, as far as the visual goes:
Any help would be greatly appreciated!