5 Replies · Latest reply on Jan 3, 2018 12:12 PM by Adam Stout

    Report on Yes/No survey responses

      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