Survey Management/Assessment Instance Questions

Dan Brown2
Kilo Sage

Hello,

I have created a survey with questions using the data type Choice.   The Assessment Metric Definitions have a Display and Value (the value being numerical).     When a person completes a survey it can be found under the Assessment Instance, with the questions/answers under the Assessment Instance Questions, the Choice is found under the Value column, but is only represented by the numerical Value field.  

How can I report or even view the Display value of the Choice answer, other than go back into the question and view the choices?

Cheers,

Dan

5 REPLIES 5

Dan Brown2
Kilo Sage

I Was thinking to maybe copy the value's display to the string_value field using a business rule, I have not done too much scripting here, so any advice would be great:



setField();


function setField() {


var gr = new GlideRecord("asmt_metric_definition");


gr.addQuery("metric", current.metric);


gr.addQuery("value", current.value);


gr.query();


current.string_value = gr.display; //"test";


}


I have had a similar desire to show the display value of the resulting choice answer instead of just the numeric. This solution sounds like a good starting point. Appreciate you sharing this idea.

We have a customer that is looking to easily see the answers to questions for one assessment at a time. Seems like the only way to see that is to view the user's response, which will show the assessment form as it appears to the person taking the assessment. This method isn't quit ideal. Being able to run a report to see multiple resulting answers showing their display type value would be great.

I will come back if I discover any other solution, but so far this seems like the best idea. It also helps if you are looking to report of answers based on the string value instead of the decimal value (used for metrics).

This is actually a near identical approach we took so far and has been working well for the customer.

tom_c
Kilo Explorer

This is probably too late for you, but I just had the same requirement so I figured I'd post another solution.

The Display Value appears in the Metric Result->Instance related list if you can add that to the Assessment Instance form instead of the Assessment Instance Question->Instance related list.