Report on Yes/No survey responses

[peternemeth]

Dear SN Community,

We have a survey with a "Yes/No" question.

I would like to create a report showing a pie chart with the percentage of Yes and No answers.

So I would create a report on the asmt_metric_result table, filter on the records and "group by" the answer.

My problem is that the result is stored in the "String value" field. But you can't group by a string field.

I can only group by on the "Actual value" field. But that stores only 0/1. Zeros and Ones do not look good in reports...

Is there any way to show the percentage of Yes/No answers and labeling them correctly without 0 and 1?

Thank you

Peter

[Dennis R]

Are you doing this from the Report Creator? I can group by String Value, I'm not sure why you're unable to. See screenshot below, are you seeing something different?

[peternemeth]

I do not see the "String value" in the "Group by" field. I tried it in Jakarta and Kingston with the same setting... I have no idea why!

[Adam Stout]

I believe you can't group by string fields.   Can you group by the actual value?

[JessyJimenez]

Were you able to figure this out? I'm in the same situation.