What is the difference between table "Assessment instance question" and "Metric Result"

VIKAS MISHRA
Tera Contributor

‎09-19-2023 07:46 AM

We have 2 different report to show the filled survey by users one report is created on table "Assessment instance question" and another one is created on "Metric Result", both are to show the survey filled between a particluar date but both report are giving the differnt count of data. 

 

What is the difference between both the tables.

Which table we should actually use to get the filled survey.

Sharing screnshot below that showing the filter of both report so that you can see if there is anything wrong.

 

VIKASMISHRA_0-1695134754392.png

 

VIKASMISHRA_1-1695134779715.png

 

0 Helpfuls
  • 2,889 Views
3 REPLIES 3

Marcos Kassak
Kilo Sage
Kilo Sage

‎09-19-2023 07:56 AM

Hi @VIKAS MISHRA,

 

  1. Assessment instance question: This table typically stores individual responses to questions in an assessment or survey. Each record in this table represents a user's response to a specific question in a specific instance of a survey or assessment.

  2. Metric Result: This table is generally used to store results of metrics defined for various tasks or records in ServiceNow. Metrics in ServiceNow are used to measure and evaluate the effectiveness of various processes.

Given the context:

 

  • If you're looking to analyze individual responses to survey questions, you'd likely want to use the "Assessment instance question" table.

  • If you're looking to analyze aggregated or calculated results based on predefined metrics, then the "Metric Result" table would be more appropriate.

 

For your reference:

 

3 Ways to Easily Report on Survey Results

 

Survey responses and results

 

If you found my answer helpful or correct in any way, please don't forget to mark it to help future readers! 👍

 

--

 

Kind regards,


Marcos Kassak
Solution Consultant  🎯

VIKAS MISHRA
Tera Contributor
In response to Marcos Kassak

‎09-19-2023 08:42 AM

Can you please tell me that why the records count is differnt in both the reports.

Can you see any reason

0 Helpfuls

Marcos Kassak
Kilo Sage
Kilo Sage
In response to VIKAS MISHRA

‎09-19-2023 09:21 AM

One table stores individual responses for each question, and another stores aggregated or calculated results, so it will be different nonetheless. 

 

What really matters is which kind of KPI you want to show, and from then on you can choose to pull from one of the two tables - at this link 3 Ways to Easily Report on Survey Results shows the difference and how to create it properly.