24:null 25:["$","title",null,{"children":"Survey Cross-Tabulation Analysis | Observable | Observable"}] 2a: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.`2b:[{"id":"54038070416ab99265b07cc9aa7e20116c12b8135d6c4e6c4e4c590dd7d797924b78beacba0bea74b69b4dd66636afc98742e0607f8de4233065adfe550ceb54","href":"https://static.observableusercontent.com/files/54038070416ab99265b07cc9aa7e20116c12b8135d6c4e6c4e4c590dd7d797924b78beacba0bea74b69b4dd66636afc98742e0607f8de4233065adfe550ceb54","name":"DVS_cleaned_survey_results_2019.csv","type":"text/csv","lastModified":1616428056621.5,"size":1688413}] 28:{"id":"a18e7dfd80f60749","slug":"survey-cross-tabulation-analysis","title":"Survey Cross-Tabulation Analysis","thumbnail":"c41a7ad32835e1f6b4067893c31ba55134266c2adb42a4b05d5a7891fe6830ee","access_level":"public","create_time":"$D2021-03-22T15:47:36.621Z","update_time":"$D2021-09-21T23:14:15.503Z","view_time":null,"first_public_time":"$D2021-05-25T14:41:59.003Z","fork":true,"stars":30,"starred":false,"owner":{"type":"team","id":"f35c755083683fe5","login":"observablehq","name":"Observable","avatar_url":"https://avatars-next.observableusercontent.com/424c6c1f7794371c9915a160519bdfb34cf34e50069fcd6def38a1a04d4e9702","tier":"enterprise_2024"},"version":937,"publish_version":937,"role":null,"authored":false,"authors":[{"type":"individual","id":"595405df3c534894","login":"enjalot","name":"Ian Johnson","avatar_url":"https://avatars-next.observableusercontent.com/549bdb0c368027004b51c4e95459e9c224331e0fec9c4cc97d181f83e55ab7f9","tier":null}],"members":[{"type":"individual","id":"074c414ad1d825f5","login":"mbostock","name":"Mike Bostock","avatar_url":"https://avatars-next.observableusercontent.com/7dbba99ced40bd5ab8013c99b1a11da61231bce321ba1148a9d16ad0f121550a","tier":null,"role":"editor"},{"type":"individual","id":"0bb2842b01e0c652","login":"tophtucker","name":"Toph Tucker","avatar_url":"https://avatars-next.observableusercontent.com/3706c31a8f9c59bb716c022c04b9c073144cd1368b78ac85f49139be6c93c34e","tier":null,"role":"editor"},{"type":"team","id":"f35c755083683fe5","login":"observablehq","name":"Observable","avatar_url":"https://avatars-next.observableusercontent.com/424c6c1f7794371c9915a160519bdfb34cf34e50069fcd6def38a1a04d4e9702","tier":"enterprise_2024","role":"viewer"}],"comments":[],"custom_thumbnail":true,"trashed":false,"subscribed":null,"forks":146,"collection":{"id":"cc508afad1566efd","slug":"templates-user-research","title":"Templates: User Research","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"type":"notebook","body":{"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","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","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","output":"$undefined","database":"$undefined"},{"id":784,"value":"viewof subset = survey.matrixCompare(question1, question2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$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","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","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","output":"$undefined","database":"$undefined"},{"id":579,"value":"$2a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$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","output":"$undefined","database":"$undefined"},{"id":576,"value":"Inputs.table(data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$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","output":"$undefined","database":"$undefined"},{"id":863,"value":"md `---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":860,"value":"md`## Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$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","output":"$undefined","database":"$undefined"},{"id":916,"value":"md `---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":575,"value":"sheet = survey.processSheet(data)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":710,"value":"question1 = questions.q1","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":712,"value":"question2 = questions.q2","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"import {survey} from \"@observablehq/survey-library\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2b","stdlib":"1","titling":"auto"}} 29:"$28:body"