Hello @NBK ,

// Create a GlideAggregate object for the incident table
var inc = new GlideAggregate('incident');

// Add a group by clause for the priority field
inc.addAggregate('COUNT', 'priority');

// Group by priority
inc.groupBy('priority');

// Query the records
inc.query();

// Iterate through the result
while (inc.next()) {
    var priority = inc.getValue('priority');
    var count = inc.getAggregate('COUNT', 'priority');
    
    gs.info('Priority ' + priority + ': ' + count + ' incidents');
}

If you found my response helpful, please consider marking it as "Helpful" or "Accept Solution." Thank you!