Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DataIsMyMN
Frequent Visitor

How to show start time, duration of each stage, and end time of daily run jobs

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:

ClientNameDeploymentDateStart TimeLag Start to Stage 1Stage 1 DurationLag Stage 1 to Stage 2Stage 2 DurationLag Stage 2 to Stage 3Stage 3 DurationLage Stage 3 to Stage 4Stage 4 DurationLag Stage 4 to End TimeEnd Time
Client A1/7/20231/7/2023 5:070.050.020.020.150.040.030.030.050.011/7/2023 10:11
Client A1/8/20231/8/2023 7:130.020.020.030.140.040.050.020.060.011/8/2023 10:09

 

And this is an example of what the requstor is hoping to see, as far as the visual goes:

DataIsMyMN_0-1675118078912.png

 

Any help would be greatly appreciated! 

 

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.