Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

Unable to Create Monthly/Yearly Business vs Non‑Business Hours Reports Using Filters

LokeshwarRV
Tera Contributor

a week ago

I am trying to build reports in ServiceNow to categorize Incidents created during Business Hours (7 AM–4 PM) versus Non‑Business Hours based only on the creation time. I have tried multiple report filters, but I am unable to achieve this correctly.

I have tried the below  filter  but no use.  
for non business hours
LokeshwarRV_0-1776801725070.png

and for business hours

LokeshwarRV_1-1776801822268.png

please help me regarding this issue

0 Helpfuls
  • 407 Views
2 REPLIES 2

Chris Plunkett
Tera Expert

Wednesday - last edited Wednesday

try something like this

 

ChrisPlunkett_1-1777491594010.png

 

 

0 Helpfuls

Laveena-Agarwal
Mega Sage

yesterday

Hi @LokeshwarRV 

is your issue resolved?

0 Helpfuls