Report for Incidents Per User Based on Hire Date

[DonnaSTLMartin]

We have a Hire Date field associated with each user. Managers want to know how many Incidents (INC) were opened for the user after their first 90 days of hire.

Without much fuss, and hopefully without having to run/calculate data on an Excel spreadsheet, is there a report in ServiceNow that will show me the number of INCs per users for a certain timeframe based on their Hire Date?

[AshishKM · Accepted solution]

Hi @DonnaSTLMartin , 

You can apply the filter condition on Incident table and 

I used caller's created date for example, you can update to caller's hire date.

You can update the instanceName in below URL and run it ... this will give the same condition as above and you can edit the Caller.Created with Caller.HireDate using the Show Related Fields.

https://instanceName.service-now.com/incident_list.do?sysparm_query=caller_id.sys_created_onLESSTHANsys_created_on%40day%40before%4090%5Eactive%3Dtrue&sysparm_view= 

-Thanks,
AshishKM