Hi,
I have this requirement where i have to create a report which shows the time spent by an assignment group in a HR case excluding 'pending' and 'on-hold' states.
I have found a OOB metric which calculates Assignment group duration in a HR case.
And I have also created a metric which calculates the time spent by an HR case in each state irrespective of assignment group.
Kindly, help me to calculate the duration of each assignment group in each case excluding pending and on-hold states.
Thanks.
