NEED HELP CREATING A REPORT FOR CALCULATING THE TURNAROUND TIME (FIELD SERVICES MANAGEMENT)

[Ram Kaushik]

I am in need of a report that calculates the total turn around time with respect to every work order over a period of time.The logic is simple:
Against every work order, I need to calculate the turn-around time (Date/time of creation - Date/time of closure).
Does performance analytics cover this metric? 
Is there an out of the box report i can use or should I be designing a new report?
It would be great if you can share a screenshot specifying the design parameters or link me to the existing report.
Thanks in advance 🙂

[Josh Cooper]

I'm not sure if we're doing this out of the box for Field Services Management, but if you look at the Metric Definitions table you should see the exact thing you're looking for, only set up against the Incident table called "Create to Resolve Duration"

Insert and Stay there, point it at the new table and new field, and adjust the script references, and it should do exactly what you want.

[Ram Kaushik]

Thanks Josh. Ur post gave me a good clarity on what is to be done.

However,while creating a similar metric for the work order table, i have a confusion on the value to be given in the if condition.
It would be great if you can share the integer values equivalent to work order states.

PS: I am a newbie to servicenow. So please bear with me