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

ebaileyybs · ‎11-05-2014

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

Anurag Tripathi · ‎11-06-2014

Hi Emma,

Lets keep things simple and get this done

Business rule script

var planned_start_date = gs.now()

var daysDuration = gs.dateDiff(current.start_date,gs.now());

current.u_lead_time =daysDuration;

/*I have tried this on demo and its works just fine(provided you planned start date has a value, you can add checks).*/

And Lead Time field is 'duration'

You can see the same if you log on to

https://demochannel.service-now.com

Create any change request

-Anurag

View solution in original post

jaybray · ‎11-05-2014

Hi Emma,

I believe you can achieve this via Metrics: http://wiki.servicenow.com/index.php?title=Metric_Definition_Support

From an Analytical, time series reporting perspective this can also be achieved via performance analytic which will provide KPI/Metric dashboarding of such trends, averages and performance.

ebaileyybs · ‎11-06-2014

Thanks Jason, I have looked into this, however, I can only base it on the duration of one field. I would like to calculate the difference between two fields and I cannot see a way to do this - I assume a script is required?

Anurag Tripathi · ‎11-06-2014

Hi Emma,

Metrics work exactly the same way as your expectation here. It the best resort .

-Anurag

Anurag Tripathi · ‎11-06-2014

IF you still don't want to use it, then you can have a simple script written that will serve your purpose. Let me know if you need help with the script.

-Anurag