Report on Asmt Metric Instance Table

[dvelloriy]

Hello All,

I am trying to create a report on Asmt Metric Results table to capture the feedback from our stakeholders.

Its looking good as i can see the feedback comments, portal page (kb_article, sc_cat_item, my_requests etc), assigned to user. However, i cannot see the actual target record on which this feedback was provided. 

Please refer the screenshot below, I pulled out a column (Instance. Portal page params) however its the results in json format. Is there a way i can parse and show the actual target record in the report to make it end user friendly.

[Andrew_TND]

Hi @dvelloriy 

Instead try reporting off "asmt_assessment_instance_question", I remember having this issue and found the "Source" linked back to the ticket, in the hirachy it also sits below "asmt_assessment_instance" so you can always dotwalk up to it if need be.

Please mark as helpful or if its resolved the issue, CORRECT!

[dvelloriy]

Thanks Andrew, I tried that as well however source is just capturing Assessment Metric Type: Experience feedback on all records.

[Andrew_TND]

---

@dvelloriy wrote:

Thanks Andrew, I tried that as well however source is just capturing Assessment Metric Type: Experience feedback on all records.

---

I've just had another look and you should have a "Task" or "Trigger ID" Field on the "asmt_assessment_instance" table which should give you the information. If that data's missing you'll need to update your survey so it pulls it through.

Please mark as helpful or if its resolved the issue, CORRECT!

[dvelloriy]

Tried that already, its not getting captured unfortunately.

It's an experience feedback dashboard report. Not sure if it works differently.