• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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

Optic

Well-known member
#1
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.
https://xenforo.com/community/threads/poll-percentages-incorrect-for-multiple-choice-polls.1761/
 

Mike

XenForo developer
Staff member
#2
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.
 

Optic

Well-known member
#3
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? :)
 

Brogan

XenForo moderator
Staff member
#4
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.
Code:
UPDATE xf_poll SET public_votes = 1 WHERE content_id = x