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

[Adam Stout · Accepted solution]

Can you create a Report ranges to translate the actual value to ranges (1 and 0)?   These are global to the table.   You may want to create a view so that this can be restricted to just this question.

[peternemeth]

Thanks, you helped me a lot!