- My View
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?
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!
I believe you can't group by string fields. Can you group by the actual value?
Thanks, you helped me a lot!