Chetan Rawat

Hi, I'm trying to find the Time a ticket spent during Business Hours in a particular field before moving out.

This is the metric I'm using to get my tickets.

IF ( [Changes - Field name] = "Current Escalation"  AND  [Changes - New value] = "X"  AND  [Changes - Previous value] = "Y" ) 
THEN [Ticket ID] 
ELSE NULL ENDIF

Now I  need a report where I will know how many hours each ticket spent in business hours and outside of business hours before the field changed from X to something else.

I tried using the following logic to create an Attribute but not working for my ask.

Separate Hours 

Let me know if there is a solution to this.

Hey ZD team, my eyes are loosing sight. Pls add a Dark Mode. Would be forever grateful.
Thanks