Unable to report on 'string value' in the asmt_metric_result table.

Craig Granier
Kilo Expert

‎06-12-2018 09:14 AM

Hi all,

I'm trying to write a report from the asmt_metric_result table.    This question I want a report on based on the template-type using the out-of-box smily faces.   It's a bar chart against a certain survey question called 'Overall Satisfaction'.   When I view the asmt_metric_result table there is a field called 'string_value' that is what I'd like to group my report on however in the reporting interface this field is not available to me.   Anyone have this happen to them?

Also, when I few this metric in the survey scorecard...it looks exactly how I want this report to look (minus some filtering we need to do for our dashboard report).

Current Version is Kingston Patch 4.

Thanks,

Craig

 

Labels:
0 Helpfuls
  • 2,514 Views
8 REPLIES 8

Nitin_NOW
Tera Guru
In response to Craig Granier

‎06-12-2018 11:20 AM

To answer 'make a report using the list view test if I could add 'string_value' to that report as a column.   Didn't show up there either' - The String Value field is always available on the table and it can be used in the List or column view in the report. I took the screenshot of the Slush bucket from my existing report as below for your reference. 

find_real_file.png

Please hit correct based on impact of response.

Thanks!

Preview file
65 KB
Preview file
65 KB
0 Helpfuls

Craig Granier
Kilo Expert

‎06-15-2018 11:00 AM

Bumping...update I did confirm I can report on 'string value' in my personal development instance so it seems to be an issue with this instance.   I'm going to open a HI ticket but in the meanwhile please let me know if anyone has come across this issue and how you fixed.

 

Thanks

0 Helpfuls

Inactive_Us1180
Kilo Guru
In response to Craig Granier

‎07-12-2019 03:02 PM

Did you ever figure out how to fix this? I am having the same issue. I can group by string value if I do an "Additional Group By" but I can't group by string as the default. 

0 Helpfuls

Dakker
Tera Guru

‎06-05-2020 12:28 PM

To resolve this you need to add attribute 'can_group' to the String Value column of the table.

  1. Navigate to System Definition > Dictionary and access the Metric Result [asmt_metric_result] table's string_value record
    • Name: asmt_metric_result
    • Element:  String_value
  2. Open the record and click Advanced View in the Attributes field, enter in 'can_group=true' (without quotes) and save.

 

See KBA article: KB0634531 - https://hi.service-now.com/kb_view.do?sysparm_article=KB0634531