Trying to build Report on Assessment Metric Result Table

[adaml]

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...

[paramveer]

Hi Adam,

Nothing wrong with your report. This is servicenow out of box functionality. As actual value is a decimal field having value -1 to 100. If system show 100 Bars according to each assessment value report will not be look good. So system just divided all values in to set of 20.

Like less   then 0(n/a)

0 to 20

20 to 40 and so on...

Its giving percentage of record. I don't think you can change it if report type is BAR only.

Thanks,

Param

[adaml]

Thanks Paramveer. So given the choices available from my report, the only available options for survey users to submit are number between 0-4. So performing a report using this asmt_metric_result table always gives me 1 bar... If this is how ServiceNow works by default for Decimal values, how can I create a report similar to what I'm looking for -- where unique values will give me unique bars on a graph, or unique slices in a pie chart?

[bridgette]

Hello, 

I am running into this issue too. Any luck? I'd just like to see how many response selected each value....

Thank you, 

Bridgette Weirich

[ryan_pope]

Hi Bridgette!

If you dive (dot walk) into the Question element from the asmt_metric_result table, you can pull the Value field from there, which provides the selected value rather than those % ranges.