Metric Result Table reporting - Do i need a DB view?

[dvelloriy]

Hello All,

I am trying to report on Metric result table and getting most of the data right. Please see screenshot below

However there is one problem. I want the HR service also included in this report. From the below report i know the HR case for which the survey response was captured. (Instance.Trigger id field). However i cannot further dot walk to HR service name.

Please advise. If we need a db view, can some one help with that?

[Dr Atul G- LNG]

Hi @dvelloriy 

Yes, you need to create a DB view with metric table.

[dvelloriy]

Hi AG, Can you help with DB view specially with the where clause?

i added 2 tables : 

1. asmt_metric_result with prefix mtr

2. sn_hr_core_case with prefix hrc and where clause mtr_trigger_id = hrc_sys_id

However, its not working and giving an error.

Please advise.

[Kieran Anson]

Take a look at the OOB incident metric table, you can then get an idea of how you'd need to set up your tables and where clause.

You can then just sub out the references for 'incident' for your HR table.

[dvelloriy]

My report is based on metric results table not metric definitions. Not sure if substituting hr with inc would work here.