Combining two metrics?

[Mark Van Loock]

Hi,

Just starting out with Metrics and needing a bit of help.

We have added a field to the incident table called "Ready for Scheduling". It's a tick box.

The department that use this want to report on the time between the ticket being assigned and the ready for scheduling tick box being ticked.

The built in "Assigned to Duration" metric captures the start date/time the ticket is assigned, and I've created a new Field Value Duration metric called "Ready for Scheduling". This also captures the start date/time when the tick box was ticket.

I'd love to know how I can combine these two metrics into a single one so I can simply have a "Start" time showing when the ticket was assigned, and an "End" time when the tick box was ticked.

Any help greatly appreciated.

Thanks!

[Dr Atul G- LNG]

Hi @Mark Van Loock 

You want to combine these and make it 1 or you want a report by combining these 2.

1st part, not possible. as metric work in single field at a time

for 2nd, you can create DB view.

[Mark Van Loock]

Hi,

I was hoping on combining them to make one - to extract from somewhere the date/time when the ticket was first assigned to either a) anyone or ideally b) the person who is ticking the tick box.

The problem I thought might be the issue is that the assignment date/time metric needs to be captured before the tick box metric is triggered.

So, if combining the two are not possible, then you say I'd need to create a new Database View. I'm currently using the built in incident_metric one. this allows me to create a report filtering by the two individual metrics but I can't get the results I need on a single line.

I'd like :

Incident Number, date assigned, date Ready for Scheduling was ticked.

What I'm currently getting is :

Incident number, metric name (assigned to), start date
Incident number, metric name (Ready for Scheduling), start date

If I create a modified database view, you think that's the way to do it?

Kind Regards,

Mark.

[Dr Atul G- LNG]

Hi @Mark Van Loock 

Yes, you can create 2 metrics Data base view.

https://www.servicenow.com/community/itsm-forum/i-have-created-a-database-view-on-metric-definition-...