Hi Nasreen2,
Yes it can be done, at least we found a way to do this.
1. You need a schedule entry to track the business days, and if you want to exclude holiday's or anything like that. This would be in the Schedule [cmn_schedule] table.
2. We created a scripted breakdown.
3. Then a bucket group for the scripted breakdown.
Here is a sample of the script we used.
Note: Our system admins do not want us hard coded sys_id's in scripts so we used a property to track the sys_id for the schedule.
var getBusinessDuration = function(x, y) {
// Get business schedule
var busScheduleSysID = gs.getProperty(<Property for the sys_id of calendar>);
var gsBusiness = new GlideSchedule(busScheduleSysID);
var busDuration = new GlideDuration();
// GlideSchedule.duration method takes 2 input parameters of type GlideDateTime
var created = new GlideDateTime();
created.setValue(x.dateNumericValue());
var updated = new GlideDateTime();
updated.setValue(y.dateNumericValue());
// Get duration based on schedule
busDuration = gsBusiness.duration(created, updated);
// Get the numeric value instead of string to use in further calculations, otherwise it will result in NaN
return busDuration.getNumericValue();
};
var busHours = function(x, y) {
return getBusinessDuration(x, y) / (60 * 60 * 1000); // Conversion from milliseconds to hours
};
busHours(current.sys_created_on, current.sys_updated_on);
