Metrics definition for certain group

[SM123]

Hello All,

I'm trying to create a metric definition on task table, on assigned to field. But my matric should only calculate where assignment group is "Prep Group". I believe type should be script calculation duration. could anyone help me with what I'm doing wrong in this code.

if (!current.active) {

	if (current.assignment_group == 'PREP group Sys_id')
        createMetric();
}
    function createMetric() {
        var mi = new MetricInstance(definition, current);
        if (mi.metricExists())
            return;

        var gr = mi.getNewRecord();
        gr.field_value = value;
       gr.calculation_complete = true;
        gr.insert();
		
    }

[Shubham_Jain]

@SM123 

(function calculateMetric(previous, current) {
    // Ensure 'assigned_to' field is updated
    if (previous.assigned_to == current.assigned_to) {
        return; // Exit if there is no change in assigned_to
    }

    // Get the "Prep Group" sys_id (Modify if needed)
    var prepGroupSysId = 'YOUR_PREP_GROUP_SYS_ID'; 

    // Check if the assignment group is "Prep Group"
    if (current.assignment_group == prepGroupSysId) {
        // Calculate duration in seconds
        var duration = (new GlideDateTime().getNumericValue() - new GlideDateTime(previous.sys_updated_on).getNumericValue()) / 1000;
        
        return duration;
    }
})();

[SM123]

Hello @Shubham_Jain ,

I kept type as field value duration because when i kept type as script calculation it is not returning any value. But this code is returning value even when i changed assignment group to different group/different group assignee.  it should only work for PREP group assignees. Yes, i'm replacing with sysid of prep group

'YOUR_PREP_GROUP_SYS_ID';

 Thank You!

[Shubham_Jain]

@SM123 

(function calculateDuration(task, metric) {
    var duration = 0;
    var audit = new GlideAggregate('sys_audit');
    
    audit.addQuery('documentkey', task.sys_id); // Get history of the task
    audit.addQuery('fieldname', 'assignment_group'); // Track only assignment group changes
    audit.addQuery('newvalue', 'YOUR_PREP_GROUP_SYS_ID'); // Only track when it is assigned to PREP group
    audit.addAggregate('SUM', 'duration');
    audit.query();
    
    if (audit.next()) {
        duration = audit.getAggregate('SUM', 'duration'); // Get total time spent in PREP group
    }
    
    return duration; // Return calculated duration
})(task, metric);

[SM123]

Hello @Shubham_Jain ,

Now it's not working for none of the groups. Do i have to add any Sysid here ?

audit.addQuery('documentkey', task.sys_id); // Get history of the task

[Shubham_Jain]

@SM123 yes please try