I want to plot a line graph showing how long each job duration takes to run successfully. X axis has dates. Y axis will have duration when job_status is 'Completed'. A job runs parallaly multiple times. I need to perform an aggr operation on job_id and fetch the min of start_time and max of end_time and obtain the difference to get the correct interval. Help form expression.
job_id
start
end
status
1
10 Jan 2024 8:25 AM
10 Jan 2024 8:35 AM
Completed
1
10 Jan 2024 8:32 AM
10 Jan 2024 8:38 AM
Completed
1
10 Jan 2024 8:34 AM
10 Jan 2024 8:45 AM
Completed
1
10 Jan 2024 8:39 AM
10 Jan 2024 8:50 AM
Completed
2
10 Jan 9:am
10 Jan 2024 9:10 AM
Completed
2
10 Jan 2024 9:05 AM
10 Jan 2024 9:20 AM
Completed
By this table, job i ran for 25 minutes and job 2 ran for 20 minutes.
