Forum Discussion
Overlapping Dates times aging calculation
Hello Community! I need help! I'm trying to calculate the aging between submit time and closed time of incidents by process, But in my case, there is an overlapping scenario happening for most of t...
pretty much all of these are overlapping. what makes the one starting at 8/3 so special?
Thanks for the reply!
In this scenario, pretty much all projects have overlapping incidents, what makes the one in the example special is that it is the first one that starts the overlapping stream, so I need the submit date for this one (start of the overlapping stream) and the last date (close date) at end of the stream.
That pattern can happen in more than one time at. I mean i can have like 1~3 months of overlapping and after that an isolated value without overlapping and then start the overlapping again.