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.