reporting on a survey response

Discussion created by rubinjm on Aug 12, 2016
Latest reply on Aug 13, 2016 by philmodjunk

I have a calculation field named Faculty Whiteboard that specifies "Y" or "N" based on the answer to a survey question.


Calculation is

If (Surveys::_pk_SurveyID = 6 and Questions::Order = 1 and PatternCount(Response; "Attending Name") > 0; "Y" ; "N")



One of the fields in the Respondents table is Faculty Name. I would like to create a report that lists the percentage of "Y" answers for each Faculty Name. I'm not sure the best way to approach this. (Not sure if I've supplied enough info here.)