XF 1.4 Display members who voted for each choice in a multi-choice poll


Well-known member
Just wondering if it's possible to display a breakdown or list that shows which members have voted for each option in a poll?

It's mainly for curiosity as I find the percentages confusing for multiple choice polls (i.e. they don't add up to 100%)

I'm aware that the percentage behaviour is "as-designed" behaviour due to the percentages being calculated by dividing total number of voters vs. total number of votes.


XenForo developer
Staff member
If the poll is public, when viewing the results, clicking on the number of votes for a choice will display the users that voted for it.


Well-known member
Thanks, I missed that option.

Is it possible to enable this option once the poll has been created or would a change need to be made to the database?

If so, can you advise what the query would be? :)


XenForo moderator
Staff member
You would need to check the xf_poll table, locate the poll based on the id or title and then change public_votes to 1.

You can also do it with a query based on the thread ID.
Be careful though, as your members may consider it a breach of privacy.
UPDATE xf_poll SET public_votes = 1 WHERE content_id = x