Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone help me with how to do a set expression to calculate elapsed time, given this table? It can't be done in the load script, because i need to compute it ad hoc, based on user selections:
Log ID | Start Date Time | End Date Time | Affected ID |
1 | 10/03/2022 8:00 | 10/03/2022 10:00 | A |
1 | 10/03/2022 8:00 | 10/03/2022 10:00 | B |
1 | 10/03/2022 8:00 | 10/03/2022 10:00 | C |
2 | 10/03/2022 9:00 | 10/03/2022 10:30 | A |
3 | 10/03/2022 14:00 | 10/03/2022 15:00 | A |
I am having trouble when Start and End times overlap.
My intended output for the Total Elapsed Time of Affected ID A = 210 mins.
Thank you.
If can't be done thru set expression, could it possibly be done in the load script?