Reporting on String Value for Group by

[ZGauss]

Hello,

I am currently trying to create a report that shows the results (string value) of a certain question within a survey. I have it setup to look at the asmt_metric_result table and want to have it Group by string value. Unfortunately I cannot figure out why it won't let me group by "string value" as the main group by category. I choose a random group by category then go to additional group by it allows me to add string value.

Any thoughts?

[Brian Lancaster]

you cannot group by string fields.  Since strings can be any combination of characters there is not way to group by it.  It is a bug that you can choose a string field in the additional group by.

[ZGauss]

I had thought it might be a bug... But it shows exactly what I need it to. Is there a better way to report on a specific yes/no question in a survey. I just need to create a report that shows the total amount of yes values and total no values in survey question  "Are you satisfied with your overall experience?" for all surveys.

[Brian Lancaster]

I think in this case you would have to export it to excel and then group it there.  I'm note sure there is any way to do this in the system.