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?

[Kieran Anson · Accepted solution]

Ah sorry, is this 'asmt_metric_result'? If so ,you can copy the database view 'task_assessment_detail'

[Dr Atul G- LNG]

Hi @dvelloriy 

I agree with @Kieran Anson , and I think you need to add 1 more table. Have a look OOTB:

[dvelloriy]

Report i am trying to pull is based on survey results captured in metric results table. 

i don't think we can leverage this OOTB db view. These are mostly for capturing state change durations etc. I am using few dot walked fields in my report to extract trigger id which is present in instance table.