Number of days a requisition is suspended

Summary

Asking if it is possible to calculate the number of days a requisition is suspended (regardless of the number of times it is suspended) in OTBI

Content

Hello everyone,

I'm trying to build an OTBI report wherein I need to calculate the number of days a certain requisition is suspended. I tried building my report using "Recruiting - Recruiting Events Real Time", since you can find the state of a requisition (Event State Code) as suspended in that subject area. However, the limitation in the report that I was able to create was that I can only calculate the suspended days of a suspension only if a requisition is suspended once. However, I would like for my report to be able to calculate the total number of suspended days,