Get long list of all the options and how many people voted for each

  • jackbgarvey
    Asked on January 19, 2021 at 1:14 PM

    The Report feature seems to be created with a focus on a single page, Powerpoint kind of use.

    I am creating an election for a school district (https://form.jotform.com/210136507185046), and I want to be able to see all the selection and checkbox entries to determine who was the winner at each school.

    I am using the report builder (https://www.jotform.com/reports/21018435135804819), and what I would really like to see is a long list of all the options and how many people voted for each, but the format of the report seems to be geared toward a single page which is too short to display all the votes for elementary schools (which is almost 100).

    How do I do this or see this display of information. The bar chart is great, I just need to be able to see all the entries on one long scrolling page.

    Thank you,

  • David JotForm Support Manager
    Replied on January 19, 2021 at 4:29 PM

    Hi, that is not possible with the visual report, you can only create a chart(donut, pie, column and bars) to see who got the most votes, and also what percentage that is. I see that you have done it already:

    1611091759 60074f2f289b3 pie Screenshot 10

    Note: it is showing you 6, because that is the option limit you have set.

    A workaround would be exporting your data to Excel: https://www.jotform.com/help/44-how-to-export-form-data-to-excel

    So, you could create a pivot table:

    1611091668 60074ed4b998d pivottable Screenshot 21

    Let us know if you have more questions.