on 05-05-2015 1:02 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.