Metric definition for incident

[Drishti]

Hello Community,

I have a requirement to create metric on incident table to show count of state changes within single incident.

Along with this I have to : 

1. Show incident

2. Show Assignment Group

3. Show SLA met ( Yes/No)

Please guide how can I proceed so that this can be accomplished in single metric creation .

Thanks in advance !

[Dr Atul G- LNG]

Hi @Drishti 

Yes, it is 100% possible for the 1st part\you to use OOB metric on Incident state which can provide you with the state movement.

1. Show incident. --> You can use the metric itself:

1. Show Assignment Group

Atul:  You can create the database view of metric tabe and incident table.

1. Show SLA met ( Yes/No)

Atul: You can create a database view using the above database view or use the out-of-the-box (OOTB) database view logic and concatenate it with the new database view you'll create to retrieve the assignment group.

It’s a bit lengthy, but doable.

[Drishti]

Hi @Dr Atul G- LNG 
Thanks for your reply.

I have never used database view earlier, will you please mind, guiding little bit more about how we can create database view and what all conditions needed to get desired output.

Again thanks in advance !

[Dr Atul G- LNG]

Hi @Drishti 

https://www.servicenow.com/docs/bundle/yokohama-platform-administration/page/use/reporting/reference...

https://www.servicenow.com/community/developer-forum/database-view/m-p/1459496#:~:text=A%20database%....

https://www.servicenow.com/docs/bundle/yokohama-platform-administration/page/use/reporting/concept/c...

Check this OOTB Database view