Create a Cross Tab report

This report displays the joint distribution two or more variables.

For example, you can use a Cross Tab report to break down the results by region or gender.

Note:

  • Open-ended questions are not displayed in the Topline report. They do appear in Verbatim reports.

  • All completion time calculations, except median, use a formula for calculation where only values within one standard deviation of the mean are used. This is because some people respond over a number of days, which skews the numbers.
  • In this report, the base count is the number of participants who answered the question used for the row.
  • This report displays up to 18 columns.
  • If the simple weight set feature is enabled in your community, you can create a simple weight set and then add it to the report.
  1. In Power Survey Authoring, click the Reports tab.
  2. From the New report list, select Cross Tab and then click Create.
  3. In the New Study Report, type a name for the report and then click OK.
    This name appears in the list of reports on the Reports tab.
  4. From the Data Set list, select one of the following:
    • Live: The result of the real responses to the survey.
    • Test: The result of testing your survey.
  5. From the Viewing Format list, select one of the following:
    • On Screen: Displays the results on the screen.
    • PDF: Exports the report to a .pdf file that you can download and view with Adobe Acrobat.
      Note: PDF format does not support reports with multibyte characters such as Chinese and Japanese. For best results, select Excel.
    • Excel: Exports the report to an .xls file that you can download and view with Microsoft Excel.
    • Image: Exports the report to a .tif file that you can download and view with any image viewing software.
  6. Optional: To filter the survey responses that are included in the report, click Edit Filter.
  7. Select which questions to include as banners (columns).
    1. Click Edit Banner.
      A box appears with an open space on the right and a list of questions on the left, including hidden questions. Only questions on the right are included as columns.
    2. To add a question, right-click it and then select Add.
    3. To delete a question, right-click it and then select Delete.
    4. Click OK when you are finished.
  8. Select which questions to include as rows.
    1. Click Edit Questions.
      A dialog opens. Available questions, including hidden questions, are listed on the left. Only questions in the box on the right are included in the report.
    2. To move the question from the left side to the box on the right, do one of the following:
      • Drag the question to the box on the right.
      • Right-click the question and then select Add.
      • To add all the elements in a survey, right-click an element and then select Add All.
    3. Optional: To delete a question, right-click it in the box on the right and then select Delete.
    4. Click OK when you are finished.
  9. From the Significance (95%) list, select Yes or No.
    For more information, see Significance testing.
  10. From the Language list, select a language.
    Note: If the survey is translated into more than one language, you can select which language to view the report in. The question and answer text appear in that language in the report, but the reporting interface is always in English.
  11. Optional: If the simple weight set feature is enabled, make a selection from the Apply Simple Weight Set list.
  12. Optional: Set up a schedule for automatically sending the report at regular intervals.
    Note: To send out reports automatically, you must select a viewing format other than On Screen.
    1. Select the Recurrence check box.
      The Recurrence section opens.
    2. In the Recipients field, type each email address that you want to send the report to.
      • To place the email addresses on separate lines, press Enter after you type each one.
    3. Select the start date.
      1. To open the calendar, click the Start Date field.
      2. Click the < and > keys to navigate the months, and << and >> keys to change the year.
      3. Click the desired date.
    4. In the Interval section, set up how often the reports are sent.
  13. To save the changes, do one of the following:
    • To apply the changes and keep the report open, click Apply.
    • To save the changes and close the report, click OK.