Once a survey has a completed response, there may be a need to filter the responses by different criteria or the need to export data to be organized into a different format, such as charts or graphs, to allow for reporting.
There are 2 methods to report on data from surveys from within the Surveys module.
- Use Survey Filters to create live reports inside of the Surveys module to review surveys.
- Use Export Survey Data to export a comma-delimited file (CSV) file with the selected data.
Report filters provide the ability to limit the set of responses in the reports based on custom filter criteria.
You can use one of two types of report filters: Issuetrak type filters or managed filters. Issuetrak suggests you use only one of the above filter types at a time.
- Issuetrak filters allow you to filter on characteristics of the issue that is related to the survey response submitted, such as priority, issue type, or department.
- There are two types of managed filters: Date and Question.
- Date filters limit the responses to only the dates within the specified range. Question filters limit the responses based on answers to questions in the survey.
- Question filters vary depending on the type of question selected. Answers can be set to be equal to a response, contain a response, or, in the case of number and date questions, be greater than or less than a certain value.
One or more managed filters may be applied to a survey. All of the filters are combined using AND logic, meaning that all filters must evaluate to “True” in order for a response to be included in the results.
If a report has filters, the filters are applied to the overview report, the individual report, the text report, and the data export functionality.
When working with a report with many questions, you may want to run multiple reports with various combinations of filters. Rather than deleting filters, you can set any filter to active or inactive on the page that displays the main list of report filters.
The Export Data page enables a user to export the responses to a survey. The data is exported as a comma-delimited file (CSV), which can be opened with Excel.
There are three formats for exporting the data format.
|User Responses||Exports one row of data, per entire response, with each of the questions displayed as a column.||
|Individual Responses||Exports each individual response on its own row.||
|SPSS Format||Exports each response as a row, with one column per possible answer to each question.|
In addition, the Export Data page contains a series of optional fields, each preceded by a checkbox. Any field that is selected before exporting the data is included as a column of data in the CSV file.
The additional data fields that can be exported include both response and user data.
|The optional response fields are:||The optional user fields are:|
|● Username||● First Name|
|● IP address||● Last Name|
|● Date started||● Email Address|
|● Time started||● Company|
|● Date completed|
|● Time completed|