25:["$","title",null,{"children":"Survey Cross-Tabulation Analysis | Jamie LaPaglia | Observable"}] 49: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.`4a:[{"id":"54038070416ab99265b07cc9aa7e20116c12b8135d6c4e6c4e4c590dd7d797924b78beacba0bea74b69b4dd66636afc98742e0607f8de4233065adfe550ceb54","href":"https://static.observableusercontent.com/files/54038070416ab99265b07cc9aa7e20116c12b8135d6c4e6c4e4c590dd7d797924b78beacba0bea74b69b4dd66636afc98742e0607f8de4233065adfe550ceb54","name":"DVS_cleaned_survey_results_2019.csv","type":"text/csv","lastModified":1667902527748.759,"size":1688413}] 29:{"id":"86d9ee7394b114ee","slug":null,"title":"Survey Cross-Tabulation Analysis","thumbnail":"8b626da977d0242b86df1ed7df409164ecb4805dde5048ae19e732d4aec1cfe3","access_level":"public","create_time":"$D2022-11-08T10:15:27.748Z","update_time":"$D2022-11-08T10:15:27.748Z","view_time":null,"first_public_time":"$D2022-11-08T10:15:27.748Z","has_unpublished_edits":null,"fork":{"id":"a18e7dfd80f60749","slug":"survey-cross-tabulation-analysis","title":"Survey Cross-Tabulation Analysis","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"stars":0,"starred":false,"owner":{"type":"team","id":"3d7d3bdc6da7fe30","login":"claimclarity","name":"Jamie LaPaglia","avatar_url":"https://avatars-next.observableusercontent.com/5bd04b352319395640172458b136a8c0e8d5b1b5d1360bed031b60686b8707f6","tier":"starter_2024","bio":"","following":false},"version":937,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"3a39330b7c23120f","login":"claimclarity","name":"Jamie LaPaglia","avatar_url":"https://avatars-next.observableusercontent.com/5bd04b352319395640172458b136a8c0e8d5b1b5d1360bed031b60686b8707f6","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"3a39330b7c23120f","login":"claimclarity","name":"Jamie LaPaglia","avatar_url":"https://avatars-next.observableusercontent.com/5bd04b352319395640172458b136a8c0e8d5b1b5d1360bed031b60686b8707f6","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":585,"value":"viewof questions = survey.compareQuestionSelector(sheet, {index1: 0, index2: 1, free2: false})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":784,"value":"viewof subset = survey.matrixCompare(question1, question2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":579,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":578,"value":"data = await FileAttachment(\"DVS_cleaned_survey_results_2019.csv\").csv({type: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":576,"value":"Inputs.table(data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":863,"value":"md `---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":860,"value":"md`## Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":916,"value":"md `---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":575,"value":"sheet = survey.processSheet(data)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":710,"value":"question1 = questions.q1","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":712,"value":"question2 = questions.q2","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"import {survey} from \"@observablehq/survey-library\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4a","stdlib":"1"}} 24:null