How to report on days since assignment status change
I am looking to report on days since Leave. We track leaves using the Assignment Status field, so I am looking to report on days since assignment status change.
I am noticing that when I report using the Assignment Event Real Time, I can get multiple rows with the HR Actions pulling back the Assignment Status where it is still the same. I am wondering if I am able to pull back records that just indicate a change in the status for purposes of calculating total time in the Assignment Status.
Does anyone have an example or understanding of how to do this in OTBI?