Reporting on METRIC_INSTANCE

[kirti0604]

Hi All,

I have a requirement in which I need to fetch the State duration of each states viz. New ,assigned, WIP .

So I have configured one report on metric_instance table and querying it accordingly. While it suffice the requirement, but there has been one more addition to it. I need to show the Incident PRiority on that report as well. The problem here is,   I cannot drill down ID field of metric_instance table as it is document ID field and not a reference one. Please   let me know if you all have any workaround for the same.

[Jaspal Singh · Accepted solution]

Hi Rishi,

All you need is to used OOB Metric database view for metric reporting with below filter conditions

[neha15189]

HI ,

You could create a new field "Incident Number" on the metric instance table which references the incident table. And populate the value of this field for your definition. Once you have a reference field ,you will be able to access all fields on the incident table.

Regards,

Neha

[Raghu47]

Hi Neha, can you please tell how to add a new field in 'METRIC_INSTANCE' table and the right required for that?

Thanks

-Raghu