Forum Discussion

Sab's avatar
Sab
Icon for Helper V rankHelper V
3 years ago

Duration between thread times

Hello   I have a table with some duration data (see the table below). I need to calculate the duration with the following conditions:   1. If the time between threads in different tables is overl...
Need Help
Sab's avatar
Sab
Icon for Helper V rankHelper V
3 years ago

Hi ryan_mayu 

 

This works for the sample data, but we need to take two things into account: 

 

1. Not always the Max thread in the table finishes last, therefore we need to get the Max end time, instead of last value

 

2. When we have the threads from different tables running in parallel, the total shouldn't add the time like it does now!

 

Please consider making a call so we fix this together (check DM) 🙂

 

Thank you!