Perecentage of Reponses

[CQuinn]

Thanks to the help of another responder earlier, I solved part of my question but I do have one additional one as I am still very new to Alteryx.

If my data currently looks like this: 

Manager #	Q1	Q2
Ryan	Positive	Not Positive
Bryan	Positive	Positive
Ryan	Not Positive	Positive
Bryan	Not Positive	Positive
Chris	Positive	Not Positive
Chris	Positive	Not Positive

Is it possible to have Alteryx provide me the % of responses for each question that were positive? So for example:

Manager #	Q1	Q2
Ryan	50%	50%
Bryan	50%	100%
Chris	100%	0%

Thank you, community! 

[binuacs]

@CQuinn One way of doing this

[Qiu]

@CQuinn 
Similar approach but I made some twist.

if the responses only contains Positive and "Not Positive" then we can change "Positive" to 1 and do the Count and Sum as below.