https://www.servicenow.com/community/platform-analytics-forum/calculate-the-duration-of-each-assignment-group-spent-for-each/m-p/2742053#M55780 <P>Hi&nbsp;<a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/272080">@AndersBGS</a>&nbsp;</P><P>&nbsp;</P><P>Thanks for your reply, Yes I could not find anything in OOTB. Could you please guide me where can be do the scripting in PA for achieving this requirement.</P><P>&nbsp;</P><P>Regards,</P><P>Vinay T K&nbsp;</P> Thu, 23 Nov 2023 13:12:11 GMT Vinay T K 2023-11-23T13:12:11Z https://www.servicenow.com/community/platform-analytics-forum/calculate-the-duration-of-each-assignment-group-spent-for-each/m-p/2741919#M55776 <P>Hi Team,</P><P>&nbsp;</P><P>I would like to know is there any way to calculate the duration of each assignment group spent for each state in an incident in Performance analytics.</P><P>eg: INC12345 is in 'work in progress' state and three assignment group worked in this state, such as group A, group B, group C. How to calculate the duration for each group spent under Work in Progress state in PA . Breakdown matrix and breakdown relationship work for this?.</P><P>Please share your thought on this.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 23 Nov 2023 11:34:47 GMT https://www.servicenow.com/community/platform-analytics-forum/calculate-the-duration-of-each-assignment-group-spent-for-each/m-p/2741919#M55776 Vinay T K 2023-11-23T11:34:47Z https://www.servicenow.com/community/platform-analytics-forum/calculate-the-duration-of-each-assignment-group-spent-for-each/m-p/2741986#M55777 <P>HI&nbsp;<a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/559165">@Vinay T K</a>&nbsp;,<BR />I trust you are doing great.<BR />If i uderstood the query right the below code will be helpful.</P> <LI-CODE lang="markup">var incidentSysId = 'sys_id_of_incident'; // Replace with your incident sys_id var state = 'state_code'; // Replace with your state code var durationByGroup = {}; var gr = new GlideRecord('incident'); gr.addQuery('sys_id', incidentSysId); gr.query(); if (gr.next()) { var history = new GlideRecord('sys_history_line'); history.addQuery('field', 'state'); history.addQuery('new', state); history.addQuery('parent', incidentSysId); history.orderBy('update_time'); history.query(); var startTime; var endTime; var currentGroup; while (history.next()) { if (history.getValue('new') == state) { startTime = history.update_time; currentGroup = gr.assignment_group; } else if (history.getValue('old') == state) { endTime = history.update_time; if (currentGroup) { var duration = gs.dateDiff(startTime, endTime, true); durationByGroup[currentGroup.getDisplayValue()] = (durationByGroup[currentGroup.getDisplayValue()] || 0) + duration; } } } } // Output duration by group for (var group in durationByGroup) { gs.info('Group: ' + group + ', Duration: ' + durationByGroup[group] + ' seconds'); } </LI-CODE> Thu, 23 Nov 2023 12:18:02 GMT https://www.servicenow.com/community/platform-analytics-forum/calculate-the-duration-of-each-assignment-group-spent-for-each/m-p/2741986#M55777 Amit Gujarathi 2023-11-23T12:18:02Z https://www.servicenow.com/community/platform-analytics-forum/calculate-the-duration-of-each-assignment-group-spent-for-each/m-p/2742015#M55778 <P>Hi&nbsp;<a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/265565">@Amit Gujarathi</a>&nbsp;,</P><P>&nbsp;</P><P>Thanks for your reply, But I am mainly looking this for reporting purpose in the performance analytics. I have already created the database view connecting metric table with incident table, and created indicators for incident state with breakdown incident state and incident assignment group. But it is not showing specific duration respected to the assignment group in each state.&nbsp;<STRONG><SPAN>Breakdown matrix </SPAN></STRONG>will work for this case?</P><P>&nbsp;</P><P>Regards,</P><P>Vinay T K</P> Thu, 23 Nov 2023 12:41:17 GMT https://www.servicenow.com/community/platform-analytics-forum/calculate-the-duration-of-each-assignment-group-spent-for-each/m-p/2742015#M55778 Vinay T K 2023-11-23T12:41:17Z https://www.servicenow.com/community/platform-analytics-forum/calculate-the-duration-of-each-assignment-group-spent-for-each/m-p/2742037#M55779 <P>Hi&nbsp;<a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/559165">@Vinay T K</a>&nbsp;,</P><P>&nbsp;</P><P>As to my best knowledge, there is no possibility OOTB from performance analytics, as it is two different values that you would like to monitor (state and assignment group). As far as I see it, you need some sort of scripting / custom development to obtain the information.</P><P>&nbsp;</P><P><EM><STRONG>If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.</STRONG></EM></P><P>&nbsp;</P><P>Best regards</P><P>Anders</P> Thu, 23 Nov 2023 12:55:58 GMT https://www.servicenow.com/community/platform-analytics-forum/calculate-the-duration-of-each-assignment-group-spent-for-each/m-p/2742037#M55779 AndersBGS 2023-11-23T12:55:58Z https://www.servicenow.com/community/platform-analytics-forum/calculate-the-duration-of-each-assignment-group-spent-for-each/m-p/2742053#M55780 <P>Hi&nbsp;<a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/272080">@AndersBGS</a>&nbsp;</P><P>&nbsp;</P><P>Thanks for your reply, Yes I could not find anything in OOTB. Could you please guide me where can be do the scripting in PA for achieving this requirement.</P><P>&nbsp;</P><P>Regards,</P><P>Vinay T K&nbsp;</P> Thu, 23 Nov 2023 13:12:11 GMT https://www.servicenow.com/community/platform-analytics-forum/calculate-the-duration-of-each-assignment-group-spent-for-each/m-p/2742053#M55780 Vinay T K 2023-11-23T13:12:11Z