cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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 TimeLast Assigned
  Date
Last Modified
  By
Assignment
  Detail.Assigned Group
GoalProgress
INC0000000585182/10/2015
  1:27:03 PM
3/1/2015
  1:52:10 PM
dalia.serhalBusiness
  Relationship Management
Incident
  Resolution Time
Missed
INC0000000585182/10/2015
  1:27:03 PM
3/1/2015
  2:14:37 PM
dalia.serhalService
  Design
Incident
  Resolution Time
Missed
INC0000000585182/10/2015
  1:27:03 PM
2/26/2015
  2:35:48 PM
guruprasath.jayaramaService
  Design
Incident
  Resolution Time
Missed
INC0000000585182/10/2015 1:27:03 PM2/11/2015
  11:26:32 AM
hlayiseka.mkhomboService
  Improvement
Incident
  Resolution Time
Missed

Thanks in advance for your feedback and inputs.

Regards

Sherwin

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I have also tried using the formula First (Last Modified By), but it doesn't give me the correct value. i.e, the actual assignee doesn't seem to match with the Last Assigned Date.