Time in Waiting Status
I have been trying to tweak the report 'Time in Status' shared in the Analytics Cookbook: https://cloudcustomerconnect.oracle.com/posts/217d3f8d00. What I am after is adding the time of duration for rows where status is in waiting. As the duration is calculated via Custom Script, I could not find a way to reference that value in the expression (ideally I would like to create that calculation as a viariable so that I can call it out in different reports-although not sure whether that's possible).
Can you please confirm whether this cannot be done or let me know if I am missing something?