Skip to Content
0
Former Member
May 05, 2015 at 12:02 PM

Missed Incident Resoultion Time Filter Based on the Assignee in SAP BO

18 Views

Greetings!

I am trying to find a way to filter the below results in SAP BO using the BMC ITSM universe, based on the person who missed the Incident Resolution Time.

However, I have filtered the below result based on the following query:

Due Date Time > Last Assigned Date. - (Applied in the query object filter)

& Min (Last Assigned Date). - Applied on the formula of inserted tables

But, when I try to insert the Last Modified By column and the Assignment Group, it ignores all my filters and puts all the assignees who had worked on this > than the due date and time.

Please help me out to filter only the person who breached the ticket, eg: In this case, INC58518 was breached by "hlayiseka.mkhombo". I need to display only this assignee and his assigned group.

Incident
ID Due Date Time Last Assigned
Date Last Modified
By Assignment
Detail.Assigned Group Goal Progress INC000000058518 2/10/2015
1:27:03 PM 3/1/2015
1:52:10 PM dalia.serhal Business
Relationship Management Incident
Resolution Time Missed INC000000058518 2/10/2015
1:27:03 PM 3/1/2015
2:14:37 PM dalia.serhal Service
Design Incident
Resolution Time Missed INC000000058518 2/10/2015
1:27:03 PM 2/26/2015
2:35:48 PM guruprasath.jayarama Service
Design Incident
Resolution Time Missed INC000000058518 2/10/2015 1:27:03 PM 2/11/2015
11:26:32 AM hlayiseka.mkhombo Service
Improvement Incident
Resolution Time Missed

Thanks in advance for your feedback and inputs.

Regards

Sherwin