Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Trying to build Report on Assessment Metric Result Table

adaml
Mega Expert

I'm trying to build a simple report (bar chart) that shows the results of Survey Results. The values seem to be stored in the asmt_metric_results table. Whenever I try to create a simple report grouped by Actual Value (Decimal), they all come back as a percentage! Does anyone know why this is happening or what I'm doing wrong? This seems like it should be a pretty basic thing, but the behavior is confusing...

find_real_file.png

1 ACCEPTED SOLUTION

C_sar3
Giga Contributor

Perfect!

 

I'm happy that I could help you 🙂

View solution in original post

8 REPLIES 8

Hi! I just utilized string value. 

C_sar3
Giga Contributor

Hello,

 

For people that (like me) come here looking for a solution, I have been facing the same "issue" and I finally "fixed" it using the "Metric definition.Display" field instead of the "Actual value" field.

 

I hope this can help.

 

Have a nice day.

Jarrad
Kilo Contributor

We are using a 1 - 10 scale for overall satisfaction.  This worked perfectly for me. Thank you

C_sar3
Giga Contributor

Perfect!

 

I'm happy that I could help you 🙂