31:T571,instructions = md`--- ## Instructions

❶ _Fork this template_

Your changes will not be saved until you fork.

❷ _Upload a CSV_

Replace the one CSV using the File Attachment icon.`32:[{"id":"54038070416ab99265b07cc9aa7e20116c12b8135d6c4e6c4e4c590dd7d797924b78beacba0bea74b69b4dd66636afc98742e0607f8de4233065adfe550ceb54","href":"https://static.observableusercontent.com/files/54038070416ab99265b07cc9aa7e20116c12b8135d6c4e6c4e4c590dd7d797924b78beacba0bea74b69b4dd66636afc98742e0607f8de4233065adfe550ceb54","name":"DVS_cleaned_survey_results_2019.csv","type":"text/csv","lastModified":1616428056621.5,"size":1688413}] 2f:{"title":"Survey Cross-Tabulation Analysis","cells":[{"id":0,"value":"md`# Survey Cross-Tabulation Analysis\n

_[Instructions: Upload one CSV](#instructions)_

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":21,"value":"md`This template let's you quickly see the frequency of responses between pairs of survey questions using cross-tabulation and question drill-downs.\n\n---\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":585,"value":"viewof questions = survey.compareQuestionSelector(sheet, {index1: 0, index2: 1, free2: false})","pinned":false,"hidden":false,"mode":"ojs"},{"id":784,"value":"viewof subset = survey.matrixCompare(question1, question2)","pinned":false,"hidden":false,"mode":"ojs"},{"id":851,"value":"{\n if(question1.type == \"multi\" || question2.type == \"multi\") {\n return md`_The percentages above will add up to more than 100% because you have selected a question that has multiple answers per response._`\n }\n return md``\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":695,"value":"{\n if(subset) {\n if(subset.selected && subset.selected.length) {\n return md`

Showing ${subset.selected.length} responses where \n_${question1.question}_ is **${subset.selectedAnswer.a1}** \nand \n_${question2.question}_ is **${ subset.selectedAnswer.a2 }**: \n
\n${Inputs.table(subset.selected)}

`\n } else if(subset.hovered && subset.hovered.length) {\n return md`

Showing ${subset.hovered.length} responses where \n_${question1.question}_ is **${subset.hoveredAnswer.a1}** \nand \n_${question2.question}_ is **${ subset.hoveredAnswer.a2 }**: \n
\n${Inputs.table(subset.hovered)}

`\n }\n return md`_Click or hover on a cell above to see the corresponding survey results below._`\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":746,"value":"// Click one of the cross-tabs above to select a subset\n// You can download your selected subset of the data as a CSV using the cell menu to the left.\nsubset.selected","pinned":true,"hidden":false,"mode":"ojs"},{"id":579,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":578,"value":"data = await FileAttachment(\"DVS_cleaned_survey_results_2019.csv\").csv({type: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":576,"value":"Inputs.table(data)","pinned":false,"hidden":false,"mode":"ojs"},{"id":649,"value":"md`\n
\n*The demo data for this template was downloaded from the [Data Visualization Society GitHub repository](https://github.com/data-visualization-society/data_visualization_survey/tree/master/data).*\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":863,"value":"md `---`","pinned":false,"hidden":false,"mode":"ojs"},{"id":860,"value":"md`## Appendix`","pinned":false,"hidden":false,"mode":"ojs"},{"id":876,"value":"md`The visualization and data processing components that drive this template are documented in the [Survey Component Library](https://observablehq.com/@observablehq/survey-library).`","pinned":false,"hidden":false,"mode":"ojs"},{"id":916,"value":"md `---`","pinned":false,"hidden":false,"mode":"ojs"},{"id":575,"value":"sheet = survey.processSheet(data)","pinned":true,"hidden":false,"mode":"ojs"},{"id":710,"value":"question1 = questions.q1","pinned":true,"hidden":false,"mode":"ojs"},{"id":712,"value":"question2 = questions.q2","pinned":true,"hidden":false,"mode":"ojs"},{"id":4,"value":"import {survey} from \"@observablehq/survey-library\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}