A Query allows you to “slice-and-dice” your data – to examine it in segments or groups based on criteria you set. A query gives you up to the minute results, and can be shared with others.
The Queries tab allows you to create, edit, and share data queries, which are essentially questions you ask of your data. A query is not a one-time snapshot – the query is run again every time you click it, on the most recent collected data. Follow the following steps to build a query:
- To build a new query, click New
- Give the Query a name and a description – putting a good description helps you remember later what the query does.
- You can choose whether the query is shared or not. A shared query means that once it is created, any of your colleagues who have access to that survey can click on the query and see the results, just as you can. The only reason not to share a query is if it is not applicable to anyone else, or you created it just for practice.
- Select whether you want to examine live production data, or test data only, by checking the Test Data Only box. Checking the Use Test Data box is the only way to examine test data generated by Illume (covered later in this document). Click Continue.
- On the left side of the screen you will see all the items in your data dictionary, which includes the questions you asked in your survey, any hidden variables, calculated variables, and the 20 or so “DatStat Internal” variables, which are the meta-data variable captured automatically on every submission.
- Checking the box next to a data dictionary item puts it in your selected variables list on the right. As an alternative to checking an item, you can select all of the variables in the survey by clicking All, or all of the variables within a certain group by clicking the All at the start of that group. You can also choose to see only the open-text commentary questions by clicking Comment, or only the non-commentary questions by clicking Data.
For this query, you’re going to build a query that pulls all of the data for participants who answered AGE > 20. Start by clicking All for ‘All Variables’.
- You can move the order in which the variables are presented by using the up and down arrows.
<
- Since this query is only searching for submissions for those where AGE > 20, a filter needs to be added. Click the Filters checkbox
- The ‘Filters’ section will open. Now we’ll set up the filter to search for AGE > 20.
- Click Save to save your query
- Click Run Query
