Need a report that shows tickets from new hires within their first 2 weeks

[JimC028]

I'm trying to create a report that shows incident tickets created for/by new hires within their first 2 weeks of hire.  I tried to start with all tickets created from 4/1 and then added the filter caller, start date is less than 2 weeks after created.  Unfortunately the results had users that were well beyond the 2 weeks of their start date.  Any suggestions?

[brunoandrade]

The problem is that the original filter compares dates in the wrong direction—it checks if the Start Date is "up to 2 weeks after Created," instead of checking if Created is within 2 weeks of the Start Date.
The correct way is to ensure that:
The ticket was created on or after the caller's start date,
And no later than 14 days after that date.

[TheJoeDC]

Yeah that is a great report of new starter satisfaction. Below seems to give me the right data.

One other for this, sometimes new starters managers open tickets for them in that 2 week time frame. Thinking through how to capture those. 

[TheJoeDC]

Actually would recommend using affected user rather than caller for this. This way you capture tickets that are submitted for them from say their manager ("She needs rights to Oracle")

[JimC028]

Thanks all!  It looks like I need to get some combinations added to our ServiceNow instance so I can try the suggestions.  I'll let you know how it goes