The Deliverables applet provides users with several different file types for exporting reports, including Verticalized (Tableau) exports and Verticalized by List exports.
Verticalized (Tableau) reports display responses in a "verticalized" (vertical orientation) output with a single column for a question and multiple rows for each respondent record. Only some field types (e.g., multiple select questions and variables, tables, blocks, loops, and ranks) are verticalized and exported in the Verticalized File. Two additional files can be exported to pull the fields that are not considered verticalized, the Non-Verticalized File and the Non-Verticalized File with Codes. Additionally, single select fields can be appended to the verticalized export in the Export Options section.
Verticalized (Tableau) output for radio table TS32
Verticalized by List reports take a single list from the survey to display vertically ("verticalized") in order to analyze it alongside the list's related survey fields. Then, responses are displayed in a verticalized output with a single column for a question and multiple rows for each respondent record. Only survey fields that are associated with the selected list are displayed vertically. All unrelated fields will be displayed in their standard output.
Verticalized by List output for checkbox QS31
The Verticalized by List export differs from the Verticalized (Tableau) export in that it is driven by the selection and verticalization of a single list, as opposed to questions. A side-by-side comparison of these two reports can be found in the table below.
For more information on creating exports in general, see Creating a new export.
Caution: Verticalized by List exports are currently offered as a BETA release. Cross-check all data exports with a traditional export to confirm the data's accuracy.
Understanding the concept
In general terms, "verticalized" data is data that is presented in a vertical orientation where the survey question/variable is displayed in a single column in a report. Multiple rows exist for the question, where each row represents a new element related to the question. For example, a multiple select (checkbox) question with five answer choices would be presented in a single column with five rows, one row for each option. Verticalized data, then, expands by adding more rows until all the data is represented within the single column. This is the opposite of the more common approach of displaying a single survey question across multiple columns, e.g., "non-verticalized" data. This data is displayed horizontally and expands by adding columns to the right for each additional element or related data.
In IntelliSurvey's software, the term "verticalizing" means to take a survey question that would normally be displayed in multiple columns and instead display it in a single column. For example, a single select (radio) table asking about "likelihood to recommend" for three brands would normally be displayed with one row and three columns, where the single row represents the respondent, and each column represents one of the three brands. Meanwhile, in a verticalized report, the same table is represented by one column and three rows, where the column represents the table, and each row represents one of the three brands.
Since single select questions are displayed in a single column by default, the option to verticalize is not applicable. Therefore, verticalizing data is not simply "all the data appears vertical." Rather, it is the action of changing the data format from horizontal to vertical, where relevant.
Verticalized (Tableau) exports vs. Verticalized by List exports
The Verticalized (Tableau) report is similar in name to the Verticalized by List export. However, these reports differ in many ways. See a comparison below.
| Feature/Item | Verticalized (Tableau) | Verticalized by List |
| Report file type(s) | .csv | .xlsx and .sav (SPSS – Coming soon) |
| Verticalization analysis focus |
Any question type that falls into the default verticalized category could be the focus, and any appended non-verticalized question is often used for additional analysis (e.g., for filtering). The question types are grouped as follows:
|
One list is selected to be verticalized and is the focus of the analysis. |
| Question types that are verticalized | Any and all question types that fall into the verticalized category as described above. | All questions associated with the selected list that are normally verticalized will be verticalized (e.g., a checkbox question). All non-related questions are not verticalized regardless of question type. |
| How the report handles single select questions/variables | Can be appended to the end of the file. If not appended, these questions are omitted from the report. | Can be exported in the main file. This is automatically done if the question(s) use the list that was selected for the analysis. The question(s) can also be manually selected from the Field Selector to be included at the end of the file. |
| How the report handles blank or unanswered question options | Question options not seen by a respondent are not exported in the file. Therefore, it is possible for a question to have five rows for respondent A and only two rows for respondent B for the same question. | All rows are exported for all question options. If a list contains five options, both respondent A and respondent B will have five rows regardless of whether or not the options were seen in the survey. If a respondent is not shown the option in the survey, the row will be blank in the report. |
| Report development stage | Fully released; improvements still in progress and slated for future releases. | The .xlsx file is a BETA release. The .sav file is an ALPHA release (coming soon). Improvements still in progress and slated for future releases. |
| Additional SPL/syntax available |
The following tags are available:
|
None |
Comments
0 comments
Please sign in to leave a comment.