Survey report - Metric Result Table

[carlm1984]

Hello All,

I have created a report using the 'Metric Result' table.

This works for what I want, but I would like to add the Incident number in the report, which when i click on the ASG reference I can see in the call, but id like that to be added to the report (if possible with the 'Assignment group' and 'Assigned to' from the incident also)

Is this possible? or if not is there another way of doing this?

Kind Regards

Carl

[Michael Fry1]

You'll want to use the Assessment Instances table (asmt_assessment_instance). That contains Task, along with the ability to dot.walk to Assignment Group and Assigned to.

[carlm1984]

Hello Michael,

I tried using this table, but it didnt give me exactly what I needed see below

When i used the Metric table it gave me the below (which enables me to see the String Value) for comments and Satisfaction

I dont seem to get this on the Assessment table?

[Michael Fry1 · Accepted solution]

Ok, fair enough. Here's how to get the task data:

[carlm1984]

Exactly what I wanted... Thank you ever so much