Help with Metric calculation.

[imran rasheed]

I need suggestion in retrieving the metrics. 

Requirement is to get all the "On Hold reason" update on tickets, which I am able to retrieve from metrics calculation. At the same time I need to know to whom the ticket was "assigned to" when the "On hold reason" was set. As per my knowledge, we cannot retrieve two metric fields together.  If I have to retrieve it as two metrics, how can I combine it with database view? Or any other of achieving this?

[Dr Atul G- LNG]

Correct — we can’t build a metric on two fields in one go. If you create a database view, you need to make sure there is at least one common field between both tables so the view can return matching records.

You can try using a metric with the Incident table database view only, or ensure your DB view has proper join conditions with at least one shared field.

[imran rasheed]

How can I create database view with two different metric fields with a common field. I don't see any possibility.

[Dr Atul G- LNG]

Hi @imran rasheed 

The fundamentals will remain the same. Take a look at some OOTB database views.

https://INSTANCENMAE.service-now.com/now/nav/ui/classic/params/target/sys_db_view_list.do%3Fsysparm_userpref_module%3Db93a6f470a0a0b79003c94c2bd919fbf%26sysparm_clear_stack%3Dtrue