In Snap XMP, reports are built up using instructions. These instructions allow you to add text, graphics, and analyses to a report. When the report is run, the current response data is inserted into the analyses and text information.

You can insert references in your instructions. When the report is run these references are replaced with data from the survey or responses.

In Snap XMP you can insert table cell references. If you create a table, you can use references to the row labels, column labels and the table cells in the report text, notes on analyses or even in another table. This means that you can use any data that is in the table in your report, and it will automatically use the latest data.

In Snap XMP Desktop, you can create a ranked table and order the columns from highest to lowest. This means that you can automatically place the highest and lowest values in your report without needing to edit them.

This tutorial explains how to create a simple report showing satisfaction rankings. The report uses data from analyses in the report text and shows how to use ranked tables to headline important points. For example, you can automatically include the aspects your customers are least satisfied with.

This tutorial uses the Course Evaluation survey which is distributed as a sample survey with Snap XMP Desktop.

How table cell references work

Cell references are a means of inserting automatically updated data in a report (or in the notes for an analysis). A cell reference is the position of the data in the specified table.

The cell referred to can be:

• A row label (describe by tablename RN label e.g., AN1 R1 label
• A column label (describe by tablename CN label e.g., AN1 C1 label)
• A data cell described by its row and column number (describe by tablename RNCN e.g., AN1 R1C1)
• A statistic value described by its row and statistic number (where its statistic number is its position in the list of statistics, S1 being the top, given by tablename RNSN e.g., AN1 R1S1)

where N is replaced by the row or column number.

Once you have inserted the cell reference into the report, any filters applied to the whole report are applied to the table containing the referenced cell.

You can use any analysis as the basis for the reference. For example, if you wish to insert a reference to data in a chart, view the chart as a table to find the cell reference then redisplay it as a chart.

You can find out what the code for a given cell is by putting the cursor on it or clicking it. The cell reference information will be displayed in the status bar.

You can also find the cell reference details by double-clicking the cell and checking the information in the Override Analysis Value dialog.

Step 1: Deciding what goes into your report

When you create a Smart Report, it is important to plan your report. The simple report used in this worksheet will include:

• a title
• a sentence giving the number of people totally satisfied with course content (from the table AN4)
• a sentence giving the topic that most needs improvement (using ordered gap analysis)
• the gap analysis chart AN15

Step 2: Creating the instructions

The report will contain a title, an information line, and an analysis.

Add the title

1. Click Reports on the Snap XMP Desktop toolbar to open the Reports window.
2. Click New Report   to create a new report. This is created with a Tailor Analysis instruction.
3. In the Report details, click New Instruction   then select Information from the menu to add a new Information instruction.
4. In the Information window, enter the title for your report in the text pane. Leave the Title field blank (this is the title of the Instruction). Style your title text by selecting text and using the format buttons.

5. Click OK to save the instruction.

Create the satisfaction reference

1. Click Analyses on the Snap XMP Desktop toolbar to open the Analyses window.
2. Open the grid table AN4 to check which cells you need. The report uses the label of the first row, and the value in the fifth column of the first row.

3. Close the table and the Analyses windows.
4. Return to your report and add another Information instruction.
5. Enter the text “The number of people who were totally satisfied with the ” then click the Insert button and select Cell Value Field from the menu. This opens the New Cell Value Field dialog.

6. Enter the reference AN4 R1label in the box and click OK. This will put the contents of the label for row 1 of analysis AN4 in your report. When it appears in the report, it will be in curly braces. Note that the Base row is row 0.
7. Add the text ” was: ” and then insert another cell value of AN4 R1C5. Style the text and references.

8. Click OK to save the Information instruction.

Insert the gap analysis table in your report

1. In the Report details, click New Instruction   then select Execute from the menu to add a new Execute instruction.
2. In the Execute dialog, select AN15 (the Gap Analysis chart) from the Execute list.

3. Click OK to add the Execute instruction to the report.

4. Click Save to save the report.

Step 3: Testing your report

It is important to check that your report looks the way you want it and is picking up the correct data.

1. Click the Execute  button on the Report toolbar. This opens the Report Execution dialog with options to Check, Preview or run the report.
2. It is a good idea to check and preview your report on screen before sending it to a printer. Click the Printer button to select to print to a pdf file or to paper.
3. Click OK to close the printer window and then click OK to run the report. Your report will look something like this.

4. Check that the data that appears in the report is from the correct table cell. The chart includes the description, title and notes. You can stop those appearing by changing the Analysis Definition.
5. Click Analyses on the Snap XMP Desktop toolbar to open the Analyses window.
6. Open the chart AN15 and select Properties to open the Analysis Definition.
7. Select the Report Styles tab and clear the Reports Include options: Description, Notes, Analysis Text, and Title.

8. Click OK to save your changes.
9. Click Save to save the analysis
10. Click Execute on the Report toolbar to and run the report again. Your report will now look something like this.

Step 4: Putting in the best and worst values

You can put the highest and lowest values in a report automatically. This step shows you how to put the area needing the most improvement in the summary line by using a sorted table.

Create a sorted table

1. Select AN15 in the Analyses window.
2. Click Clone Analysis to make a copy of it.
3. In the Analysis Definition window showing the cloned analysis, change the Type to Table and the Order to Mean. This sorts the columns in order by the mean value, so the highest value will always appear in the first column and the lowest in the last.

4. Click OK to display the table.
5. The lowest value in this table is in the fourth column. You can reference the column label to show which area is most in need of improvement.

6. Click Save to save the table.

Add the area needing most improvement to the report

1. Open your report.
2. Open the second Information instruction (instruction 3).
3. Add the text “The area most in need of improvement is :”.
4. Insert the cell reference AN19 C4label to insert the label of the fourth column.
5. Click OK to save the changes.
6. Click Execute  to save changes and run the report again. Your report will now look something like this:

When more responses come in, you can run the report again, and it will be updated with the new data. If the outcomes are different, that will automatically be carried through to the report.

If there is a topic you would like a tutorial on, email to snapideas@snapsurveys.com

The post Creating reports that include automatic text appeared first on SnapSurveys.

Step 1: Adding the rated grid question

1. Open the questionnaire in the Questionnaire window.
2. Click New Question to create the new question that will be used for rating.
3. Select Grid First in the style list.
4. Enter the question text “Please rate the following modes of transport in order of frequency of use”.
5. Press Tab and type 1 as the first code label then press Tab again to create a new code label and repeat until you have 5 code labels from 1 to 5.
6. Press the down arrow to enter the text “Foot” in the grid label
7. Press Ctrl+Enter to create a new row in the grid. This has the style Grid Next. Enter the text for the grid label. Repeat the process for each row required.

8. Click Save .

Step 2: Setting the Rating Check property

1. Select the rated grid question then click Variable Properties to open the Variable Properties dialog.
2. In the Rating Check property select Yes then click OK.

3. Click Save .

The participant will only be able to select one choice in each rating or column of the rating grid question when they are completing the questionnaire.

Explore more question styles here.

The post Using Rating Check to ensure ranking appeared first on SnapSurveys.

You can convert single response Grid First questions to a Drag and Drop question in Snap. There are 2 types of drag and drop styles:

• Ranking allows you to rank the answer choices in the grid
• Categorise allows you to Categorise answer choices in different boxes in the grid

Possibilities include:

• Ranking answer choices in order of most favourite or most important
• Categorising answer choices by how often they are purchased or visited

Single response questions can be styled as Drag and Drop in electronic editions of the questionnaire, such as Snap Online, web, tablet, smartphone.

Step 1: Add a Grid First question to your questionnaire

This section describes adding the single-response Grid First question to your questionnaire.

1. Open your survey in Snap.
2. Open the Questionnaire window if it is not already open.
3. Add a new Grid First question.

4. Enter your question text (for example, Put the fruit in order of most favourite?).
5. Press Tab on your keyboard and enter your code labels (for example, 1st, 2nd, 3rd, 4th, pressing Tab to move through each code position).
6. Press the down arrow key to enter your first Grid label (for example, Apples).
7. Press Tab to continue entering your Grid labels (for example, Grapes, Oranges and Peaches).

Please note that you need to create the same number of grid code labels as the number of ranks or categories that you need, before converting the grid to a drag and drop question.

Step 2: Change the question style to a Drag and Drop

You convert your question to a Drag and Drop using the Show toolbar topic menu.

1. Select the Grid First question.
2. Choose the Show topic and select As Drag and Drop, and then click the Show checkbox. The Drag and Drop defaults to Categorize; select Rank. The question layout changes to a Source Panel on the left and a Target Panel on the right.

3. Select Options if you wish to edit the background colours of the panels.

4. To preview the Drag and Drop, select File | Publish to display the Publish Questionnaire dialog. The Output Method defaults to Preview Only. Click Publish. The preview will open a new window and display the question as it would appear in a web browser.

Alternatively, if you wish to create a Drag and Drop question for the purpose of categorising answer choices in different boxes (for example, how often items are purchased), you will need to change the default setting drop down of Rank to Categorize (See Step 2, point 2 above).

When the questionnaire is previewed, the Drag and Drop question will be displayed as below:

If there is a topic you would like a tutorial on, email to snapideas@snapsurveys.com

The post Drag and Drop appeared first on SnapSurveys.

This means that you can know that the first column of a sorted table will have (for example) the lowest mean value.

You can access the contents of any table cell or label, so you can dynamically access the appropriate data for whatever aspect has the lowest mean value and use that data in your report. You can also insert the text from the column label in your report.

The example below shows how to use the data from a ranked column in a report Information instruction to add dynamic text to your report.

It uses

• A table ordered by the mean percentage with the highest scores in the first column and the lowest score in the seventh column. Please note that this topic contains no information on how to create this table.
• An Information instruction which references table cells and labels from the first and seventh column

1. Set up the ratings table definition and add the Mean to the summary statistics (you will need to ensure that the mean is scored if you are analyzing coded questions).
2. Set the ordering to be by the mean.

3. Click Apply to display the table.

4. Open the report that you wish to add the dynamic information to.
5. Create an Information instruction.
6. Add any fixed text. Click Insert and select Cell Value field… from the drop-down list.
7. Enter the table name and cell or label reference that you wish to insert. The example below shows references to the cells and labels highlighted in the table T4 shown above (T4 C1 Label, T4R1C1, T4 C7 Label and T4R1C7).

8. Click OK to save your instruction.

When the report is generated, the table labels and cell values will be dynamically inserted into the report

The post Inserting dynamic data from a ranked table to put highest and lowest values in your report appeared first on SnapSurveys.