Report on time between change 'Review' state and 'Planned Start'

[ebaileyybs]

Hi,

We are looking to create a report for Change Management which will show the time between a change moving to 'Review' state and the 'Planned Start' date of the change record.

We would like the time to be calculated for every change, so the information can then be exported and we can work out an average. However if there is a way to obtain the time between Review and Planned Start for each record and an average then that would be great.

Please let me know if further information is required.

Thanks in anticipation,

Emma

[ebaileyybs]

That would be great if you could help with the script please?

[ebaileyybs]

Hi Anurag,

Thank you for your reply.

Would a script be required to achieve this type of metric?

I have very little knowledge when it comes to scripting so was looking for some advise on how this could be achieved?

Kind regards,

Emma

[Anurag Tripathi]

just confirming the requirement here. You want to calculate the difference between the planned start date and the actual time when the ticket moved to review.

Write a Business Rule

When : Before

Table: change Request

Condition: current.state.changesTo('Review')     //here you will have to provide the numerical value of the state

Script

var getUserDateFormat = gs.getDateFormat();

var dateFormatHelper = new DateFormatHelper();

var currentDate = dateFormatHelper.getDateInUserFormat(gs.now() , getUserDateFormat);     //this is the date when ticket moved to review

var planned_start_date = dateFormatHelper.getDateInUserFormat(current.start_date , getUserDateFormat);   //planned start date in the specific format

var daysDuration = gs.dateDiff(planned_start_date ,currentDate);

current.<your field where you want to save duration > =daysDuration ;

/* Duration gets calculated in format - days hours mins seconds(25 10:55:52),if you have to extract the day part from it.

dateDifference = daysDuration.split(' ');

*/

This should work

[ebaileyybs]

Thank you, I have created the business rule and added a new field to the change_request table named u_lead_time. The field is a string field but I have also tried with Integer and this doesn't work either.

Unfortunately, the 'lead time' field is not populating with the output of the script. Please could you advise if you see any errors or what could be causing this problem?

Please see below condition and script:

Condition: current.state.changesTo('-5')

Script:

var getUserDateFormat = gs.getDateFormat();

var dateFormatHelper = new DateFormatHelper();

var currentDate = dateFormatHelper.getDateInUserFormat(gs.now() , getUserDateFormat);     //this is the date when ticket moved to review

var planned_start_date = dateFormatHelper.getDateInUserFormat(current.start_date, getUserDateFormat);   //planned start date in the specific format

var daysDuration = gs.dateDiff(planned_start_date,currentDate);

current.u_lead_time =daysDuration ;

/* Duration gets calculated in format - days hours mins seconds(25 10:55:52),if you have to extract the day part from it.

dateDifference = daysDuration.split(' ');

*/

[Anurag Tripathi]

Make the Field type duration (glide_duration)

If that dosent work properly then

modify this line of the code

current.u_lead_time =daysDuration.toString() ;