We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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
  • 4,575 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