Merge answers

Combine two or more answers into a single answer option, so you can display them as a single count or percentage.

Prerequisites:

Open the standard survey report.

Note: Percentages are rounded to the nearest percent.

For example, you may want to:

  • Combine similar answers.
  • Create a top 2 box.
  • Create a bottom 2 box.
  1. On the report toolbar, click Edit.
  2. In Step 1 - Select Questions, select one or more questions for which you want to edit answers.

    You can merge answer options for these question types:

    • Single Choice
    • Single Choice Grid
    • Multiple Choice
    • Multiple Choice Grid
    • Profile variables that have been added to the report (Choice type)
    Tip:
    • Sort the question list by Question Name, Question Text, or Answers/Values.
    • Type a keyword in the Find field to search for a question by question name, question text, or answer text.
    • Click Select all to select all questions or all search results displayed.
  3. Click Next.
  4. Click the arrow to the left of the question name to expand its content.
    Note: The first question is expanded by default.
  5. Select two or more answers, and select one of the following merge options.
    Option Description
    Merge The answers are replaced by a single answer and prefixed with Merged. The original answers are no longer available.
    Merge and Append The original answers remain unchanged, but a new answer labeled Merged appears at the bottom.
    Note: After you merge and append answers the following chart types will be unavailable as the total data exceeds 100%:
    • Stacked Bar Chart
    • Stacked Column Chart
    • Pie Chart
    • Donut Chart
  6. Optional: Relabel answer text.
  7. Optional: Reorder answers.
  8. Repeat steps 4 to 7 for each question you selected.
  9. Optional: Click Back to return to Step 1 - Select Questions and change your question selections.
    Note: Any unsaved changes will be discarded.
  10. When you are finished, click Apply.
    Result:

    The Edit dialog closes and you return to the report. Counts and answer labels are updated to reflect your changes. The changes are visible in:

    • Chart or table view
    • The shared version of the report
    • Excel exports
    • Chart PNG downloads
Tip: You can further edit individual questions at any time by doing one of the following:
Option Description
  • Single Choice
  • Multiple Choice
Scroll to the question, click Customize > Edit.
  • Single Choice Grid
  • Multiple Choice Grid
  • Allocation
  • Rank Order
  • Highlighter
  • Image Upload
  • Open End
  • Numeric
  • Participant Information
Scroll to the question, click Edit.

The Edit dialog opens with the current question already selected.

Note: Merged answers cannot be used in subgroups or filters.