Background<\/h3>\n
In-survey calculations work on answers as the survey is being completed. Combine the results with text substitution (piping), routing (skip logic) and masking to change your live questionnaire; anything from what the text respondents see to the questions displayed.<\/p>\n
You perform in-survey calculations in Snap using derived variables.<\/p>\n
You can display the content of the derived variable in the questionnaire and\/or show or hide other parts of the questionnaire depending on their value.<\/p>\n
Derived variables are created from responses to other variables. The way you create them will be different for each type of derived variable.<\/p>\n
For example, you could display a derived value in the questionnaire to:<\/p>\n
- \n
- add up costs to display a total (in a derived quantity variable)<\/li>\n
- add a title to someone’s name (in a derived literal variable).<\/li>\n<\/ul>\n
If you want to change the content shown in the questionnaire, you can choose what to show by testing the value of a derived variable. You can:<\/p>\n
- \n
- change text depending on the result<\/li>\n
- show or hide questions and text depending on the result<\/li>\n
- use routing to jump to different parts of the questionnaire depending on the result.<\/li>\n<\/ul>\n<\/div>\n
See more \u2193<\/a>Hide this content \u2191<\/a><\/p>\n<\/section>\n
\n Step 1: Create the derived variable to calculate\u00a0the wait time<\/h3>\n
You can work out how long someone has had to wait for an appointment and display an apology if appropriate. You must create a derived variable to work out how long the wait was.<\/p>\n
\nThis example\u00a0assumes that the appointment time is stored in Q1<\/strong> and the time the respondent was seen (if later) is stored in Q2<\/strong>.<\/p>\n
- \n
- Click
![\"Variables](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/09\/codes.png\")
\u00a0to display the\u00a0Variables Window<\/strong>.<\/li>\n- Click
![\"New](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/09\/add.png\")
to add a new variable.<\/li>\n- Specify the\u00a0Variable details<\/strong>:
\nName<\/strong>: Delay.
\nLabel<\/strong>: Wait time to see pharmacist.
\nType<\/strong>: Derived (the variable will derive its data from the other time variables).
\nResponse<\/strong>: Quantity (the variable will hold a number of seconds).
\n![\"Smart](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/06\/der_delay.png\")
<\/li>\n- Set the value for the\u00a0Valid\u00a0<\/strong>code to be Q2-Q1<\/strong> to get the difference between the times. (Note that this calculation assumes that Q2 is greater than Q1.)<\/li>\n
- Click
![\"save\"](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/01\/save.png\")
to save the variable.<\/li>\n<\/ol>\n<\/div>\nTell me how to do this \u2193<\/a>Hide this content \u2191<\/a><\/p>\n<\/section>\n
\n Step 2: Create the derived variable to categorise\u00a0the wait times<\/h3>\n
You can band the time into separate codes using another derived variable. This will provide the appropriate apology text (if necessary).<\/p>\n
\nTimes in Snap are stored in seconds. The derived variable calculates time ranges in seconds and bands the result.<\/p>\n
- \n
- Click \u00a0on the Snap toolbar to display the Variables<\/strong> window.<\/li>\n
- Click\u00a0
on the Variables<\/strong> window toolbar to add a new variable.<\/li>\n- Specify the Variable details<\/strong>:
\nName<\/strong>: delayband.
\nLabel<\/strong>: Delay codes used for apology.
\nType<\/strong>: Derived (the variable will derive its data from the Delay<\/strong> variable that you have just created).
\nResponse<\/strong>: Single (the data will be coded into bands).<\/li>\n- Double click in the first code label and enter appt time ok<\/strong>. This is a delay of less than ten minutes.
\n![\"Derived](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/06\/vd_dellayband.png\")
<\/li>\n- Press [Tab] to move to the Values<\/strong> column. Enter delay < 601<\/strong>. This is a delay of ten minutes or less.<\/li>\n
- Press [Tab] to move to the next code label field and enter more than ten minutes<\/strong>. Then enter delay<\/strong> < 1200<\/strong> as the Value<\/strong>. This is the range ten to twenty minutes. Since the codes are checked in order, a value less than ten minutes will already have been coded.<\/li>\n
- Press [Tab] to move to the next code label and enter more than twenty minutes<\/strong>. Then enter delay < 3600<\/strong> as the Value<\/strong>. This is the range twenty to sixty minutes.<\/li>\n
- Press [Tab] to move to the next code label and enter more than an hour<\/strong>. Then enter true<\/strong> as the Value<\/strong>. This catches all numbers above 3600 seconds.<\/li>\n
- Click
\u00a0to save the derived\u00a0variable.<\/li>\n<\/ol>\nThe text in the code labels 2, 3 and 4 will be text substituted (piped) into the questionnaire when appropriate. It will not be necessary to show the text in code label 1 in the questionnaire.<\/p>\n<\/div>\n
Tell me how to do this \u2193<\/a>Hide this content \u2191<\/a><\/p>\n<\/section>\n
\n Step 3: Use the code labels in your questionnaire<\/h3>\n
You can insert the label of a selected response in your questionnaire. In this example, you insert the apology text if the delay to see the pharmacist is over ten minutes or display\u00a0appreciation text if the delay\u00a0is ten minutes or under.\u00a0These texts will be displayed in two instructions.<\/p>\n
\n- \n
- Click\u00a0
![\"Questionnaire](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/04\/228new.gif\")
to\u00a0change to the Questionnaire<\/strong> view.<\/li>\n- Go to the end of the questionnaire and press enter\u00a0to create a new variable.<\/li>\n
- Change the type to Instruction<\/strong> and type in first message text “That’s great, we aim to see all visitors within 10 minutes of their allotted appointment time.”<\/li>\n
- Press enter\u00a0to create another instruction.<\/li>\n
- Insert the first part of the apology “We are very sorry to hear that you had to wait”<\/li>\n
- Check the toolbar topic is set to Font<\/strong>, click the\u00a0[Insert…]<\/strong> button on the Questionnaire<\/strong> window toolbar and select Variable Field<\/strong> from the menu.<\/li>\n
- The New variable field<\/strong> dialog appears. Select delayband<\/strong> as the variable and Reply<\/strong> as the aspect.
\n![\"New](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/06\/new_vf_delayb.png\")
<\/li>\n- Click [OK]<\/strong>. Snap will display the question name within curly brackets {delayband}, to show that it is a text-substituted field.<\/li>\n
- Add the text “Please accept out apologies.”<\/li>\n
- Click
\u00a0to save your changes.<\/li>\n<\/ol>\n<\/div>\nTell me how to do this \u2193<\/a>Hide this content \u2191<\/a><\/p>\n<\/section>\n
\n Step 4: Show or hide the text depending on the responses<\/h3>\n
You can set when questions and instructions are to be displayed using routing conditions. Set conditions (skip logic) on your instructions so that the correct one is shown depending on the delay.<\/p>\n
\n- \n
- Select your instruction for no delay and click\u00a0
![\"Routing](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/03\/routing.png\")
on the Questionnaire<\/strong> window toolbar to open the Routing Rules<\/strong> dialog.<\/li>\n- Click [Add]<\/strong> to create a new rule and set the type to Conditionally Ask Question<\/strong>. Click [OK]<\/strong>.<\/li>\n
- Enter delayband = 1<\/strong> in the If<\/strong> field and click [OK]<\/strong>. This instruction will be shown if they had to wait less than ten minutes.
\n![\"Routing](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/06\/if_db_eq1.png\")
<\/li>\n- Select the instruction for the apology and add a new routing rule in the same way as in step 3 but this time set the If<\/strong> field to delayband > 1<\/strong> and click [OK]<\/strong>. This instruction will be shown if they had to wait longer than ten minutes.<\/li>\n<\/ol>\n<\/div>\n
Tell me how to do this \u2193<\/a>Hide this content \u2191<\/a><\/p>\n<\/section>\n
\n Step 5: Test your questionnaire<\/h3>\n
When you have set up your questionnaire, you should check it to make sure that it works the way you want.<\/p>\n
\n- \n
- Publish the survey with Preview<\/strong> enabled.<\/li>\n
- Click through the preview, entering different appointment times and times you were seen. Confirm that the apology appears with the correct text if the delay is between ten and twenty minutes, over twenty minutes or over an hour. Confirm that the appreciation appears if the delay is ten minutes or less.
\n![\"Preview](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2015\/06\/delay_pv1.png\")
<\/li>\n<\/ol>\n<\/div>\nTell me how to do this \u2193<\/a>Hide this content \u2191<\/a><\/p>\n<\/section>\n
Conclusion<\/h3>\n
This worksheet has described how to use a derived variable to decide which questions will be shown using routing. It also uses text substitution to insert dynamic text.\u00a0.<\/p>\n
The help includes two tutorials:<\/p>\n
- \n
- In-survey calculation tutorial: Displaying a total and providing an appropriate discount code<\/a>.<\/li>\n
- In-survey calculation example: displaying an appropriate greeting<\/a>.<\/li>\n<\/ul>\n
You can find out more about using derived variables to categorise responses in the section: Using derived variables<\/a>.<\/p>\n
You can see more about dynamic text in the topic: Inserting a previous response into the text of your questionnaire<\/a>.<\/p>\n
There is a worksheet on using routing to limit grid questions displayed<\/a>. You can also find out more about routing in the help section: Introduction to routing<\/a>.<\/p>\n
If there is a topic you would like a worksheet on, email to snapideas@snapsurveys.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
- In-survey calculation example: displaying an appropriate greeting<\/a>.<\/li>\n<\/ul>\n
- Click through the preview, entering different appointment times and times you were seen. Confirm that the apology appears with the correct text if the delay is between ten and twenty minutes, over twenty minutes or over an hour. Confirm that the appreciation appears if the delay is ten minutes or less.
- Click [Add]<\/strong> to create a new rule and set the type to Conditionally Ask Question<\/strong>. Click [OK]<\/strong>.<\/li>\n
- Click\u00a0
- Click
- Click