Stump the Panel » End Users and Information Workers

Modify/Manipulate Survey results

(2 posts)

Tags:

  1. eakawie
    Member

    Is there a way to modify the standard Graphical Summary from a survey? I've got a bunch of questions where the users answer with checkboxes, and the Summary displays each permutation as a seperate line, so if someone answers "A and B", it shows up as one line, and a response of "B and C." I'd like totals of each answer, so I would see A=1 B=2 C=1.

    I know I can export to Excel and manipulate there, but my boss doesn't quite accept that as the only solution.

    Posted 6 days ago #

  2. Toni
    Moderator

    The problem is SharePoint stores each answer to such question in the following format:

    1) selected_option1#;selected_option7
    2) selected_option2#;selected_option4
    etc.

    And the results display exactly that, each combination one line... :(((

    There is no easy way to solve this. Options: Excel or custom programming. In your case I would Excel and count the values...

    =COUNTIF([COLUMN], "selected_option1")
    =COUNTIF([COLUMN], "selected_option2")
    =COUNTIF([COLUMN], "selected_option3")

    etc.

    Posted 3 days ago #

RSS feed for this topic

Reply

You must log in to post.