When you wish to create a new report the first thing you need to do, is to add your report elements. When you have added the elements you'll be able to export tables and graphs to Excel.
To add an go to the Setup menu, under the Analysis tool, and click on the Cross button. A new window will open.
Type: Here you can choose between three different report types; standard, benchmark and completion statistics.
A standard report is a report where you can see the frequencies in percentages and numbers. A report element is a graph or a table created on the basis of the results of a variable/question.
Choose variables: Here you'll find a list of the variables you can choose between. Here you'll be able to see all your background variables and questions. In the drop down menu you'll need to choose the questions and click Add in the Frequency side. If you wish to remove a question/variable, select it and click on the Remove button.
The questions will then be placed under Frequency and thereby added as report elements.
Show as...: In the drop down menu choose if the report element should be shown as table, graph or both.
Click OK to add the report elements and create your report.
The report now consits of the elements you have chosen.
In the report you can edit the sequence of the element and delete report elements that you dont' want to see. If you wish to see what the report looks like just click View button under the Setup menu.
Tip: In a standard report most users are interested in seeing the number of responses, average and distribution in percentage. You can change these settings by clicking Setup and Statistics. Here tick of the elements you want added to your report.
Tip: In a cross table (or graph) you can analyze differences between departments, gender, segments or other background variables. If you wish to export a report on each department or another background variable, this is not a cross report - this is a standard frequency report with a filter. The filter can be created as either an user defined variable or a question in the survey.
Note: A background variable (BV) is a variable that has been imported from your target group file. As you can see the BV's have the same names the columns in your target group file. A user-defined variable (UDV) is a variable that has been transformed to a filter, which means that you'll be able to filter your report on it or create a cross report. You have to create your user-defined variables yourself.
Standard Frequency report
A frequency report is also called a standard report since the report shows the total in numbers and percentage on all standard questions (except texts, open text and numerical questions).
First choose the questions that should be shown with frequency. This is done by marking the question and pressing on the SHIFT button, while clicking on the questions. This allows you to add more questions at the same time. Add the questions marked with blue in the Frequency side.
A cross report shows the response distribution in accordance to a specific variable or a specific question. The questions or variable could be, e.g. gender or age. With the variable gender in cross you'll be able to see the response distribution on men and women.
The easiest way to create a cross report is by adding the variable you want to cross with, in the Cross side first. And then adding your questions in the Frequency side. When you add your questions in the Frequency side an Error message might occur.
There are two possible error messages, either that This variable cannot be crossed or You are only allowed to choose each variable once!. You have to click OK to these error messages, and the system will automatically include the question you can cross.
The elements you can cross are:
- Single questions
- Multiple questions
- User-defined variables
- Sub questions in matrixes
- Dimensions in 3D matrixes