Time Duration is the End Goal - How Best to Get There
All -- I am trying to set up a PBI report to show the timings of our nightly processes. There are four processes that we have in our log files with start and end times (assuming it completes, of course).
What I want to get to is to pull how long each process took to complete (if it did), how long did the entire process take to run. And then show the trends over the last 30 days, etc, etc.
My question is how do I best layout this data to make things easier on myself to calculate durations in PBI?
The TIMEs below are formatted "18:54:56.01", "1:46:19.99 ", etc. --- so we may have times that are technically into the next day that the process actually began.