Hi Raghu.Rudraraju
Thanks.
So what I am planning right now is to fetch data from KPI as they want timestamp for more particularly three field changes(Status,Group and Assignee) and I believe KPI ticket data covers these fields.
So I tried to get the values using the following fields in query panel and the result was not satisfactory.
Only I could see the group changes and the whole report was full of group changes and that is also for only one group change, I did not see anything related to assignee changes or anything else.
I used the following fields in the report query panel:-
Ref Num| Field Name|Field Value|Next Value|Previous Time|End Time|KPI Ticket Data Duration
But I dont get the change details of three fields in any of the report data.
I was expecting something like this:
Report Output:-
Ref Num| Field Name|Field Value|Next Value|Previous Time|End Time|KPI Ticket Data Duration
100|Group| Group A|Group B|20/04/2016 hh:mm:ss|21/04/2016 hh:mm:ss|xxxx
100|Assignee|Assignee A|Assignee B|20/04/2016 hh:mm:ss|21/04/2016 hh:mm:ss|xxxx
101|Group| Group C|Group D|20/04/2016 hh:mm:ss|20/04/2016 hh:mm:ss|xxxx
101|Assignee| Assignee P|Assignee Q|18/04/2016 hh:mm:ss|19/04/2016 hh:mm:ss|xxxx
102|Group| Group E|Group F|20/04/2016 hh:mm:ss|20/04/2016 hh:mm:ss|xxxx
102|Status| Open|Acknowledge|21/04/2016 hh:mm:ss|21/04/2016 hh:mm:ss|xxxx
103|Group| Group G|Group H|16/04/2016 hh:mm:ss|17/04/2016 hh:mm:ss|xxxx
103|Assignee| Assignee M|Assignee N|18/04/2016 hh:mm:ss|19/04/2016 hh:mm:ss|xxxx
103|Status| Open|In Progress|18/04/2016 hh:mm:ss|19/04/2016 hh:mm:ss|xxxx
How can I achieve this?
All I am getting in report right now is:-
100|Group| Group A|Group B|20/04/2016 hh:mm:ss|21/04/2016 hh:mm:ss|xxxx
101|Group| Group A|Group B|20/04/2016 hh:mm:ss|21/04/2016 hh:mm:ss|xxxx
102|Group| Group A|Group B|20/04/2016 hh:mm:ss|21/04/2016 hh:mm:ss|xxxx
103|Group| Group A|Group B|20/04/2016 hh:mm:ss|21/04/2016 hh:mm:ss|xxxx
104|Group| Group A|Group B|20/04/2016 hh:mm:ss|21/04/2016 hh:mm:ss|xxxx
105|Group| Group A|Group B|20/04/2016 hh:mm:ss|21/04/2016 hh:mm:ss|xxxx
106|Group| Group A|Group B|20/04/2016 hh:mm:ss|21/04/2016 hh:mm:ss|xxxx
Someone please help. I badly require this kind of report.
Thanks
Manirul