27:null 28:["$","title",null,{"children":"Survey Report Builder | Thad Kerosky | Observable"}] 2d: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.`2e:[{"id":"54038070416ab99265b07cc9aa7e20116c12b8135d6c4e6c4e4c590dd7d797924b78beacba0bea74b69b4dd66636afc98742e0607f8de4233065adfe550ceb54","href":"https://static.observableusercontent.com/files/54038070416ab99265b07cc9aa7e20116c12b8135d6c4e6c4e4c590dd7d797924b78beacba0bea74b69b4dd66636afc98742e0607f8de4233065adfe550ceb54","name":"DVS_cleaned_survey_results_2019.csv","type":"text/csv","lastModified":1684897446924.163,"size":1688413}] 2b:{"id":"eec80965387daa72","slug":null,"title":"Survey Report Builder","thumbnail":"14de335471ec2734bec89ce2994c4829b28b6ed5cd02e4a82e7c2b085f934c4d","access_level":"public","create_time":"$D2023-05-24T03:04:06.924Z","update_time":"$D2023-07-10T15:42:08.084Z","view_time":null,"first_public_time":"$D2023-05-24T03:04:06.924Z","has_unpublished_edits":null,"fork":{"id":"6199f85d2e085a20","slug":"survey-report-builder","title":"Survey Report Builder","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"stars":0,"starred":false,"owner":{"type":"team","id":"5cd4a42aead2029f","login":"thadk","name":"Thad Kerosky","avatar_url":"https://avatars-next.observableusercontent.com/2f2413891eb0ff4669b49685946f849544a1e49e7047923d158638bc30666281","tier":"starter_2024"},"version":1051,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"be3e6e81af18a319","login":"thadk","name":"Thad Kerosky","avatar_url":"https://avatars-next.observableusercontent.com/2f2413891eb0ff4669b49685946f849544a1e49e7047923d158638bc30666281","tier":null}],"members":[{"type":"individual","id":"be3e6e81af18a319","login":"thadk","name":"Thad Kerosky","avatar_url":"https://avatars-next.observableusercontent.com/2f2413891eb0ff4669b49685946f849544a1e49e7047923d158638bc30666281","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Survey Report Builder","cells":[{"id":0,"value":"md`# Survey Report Builder\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 makes it easy to quickly explore and understand your survey data. For each question in your survey, we suggest appropriate data visualizations to summarize the responses. You can build up a custom survey report by collecting the visualizations you are interested in using.\n\nSee [**this tutorial**](https://observablehq.com/@observablehq/user-research-survey-report-builder-tutorial?collection=@observablehq/observable-templates) for a quick overview of how to use this template.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":910,"value":"md `---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"viewof question = survey.questionSelector(sheet, {startIndex: 0, maxSelections: 1})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"f = {\n \n if(question === null) return md`**Select a question to see a visualization.**`;\n let str = survey.serveQuestion(question).code\n // this is super shady!!!!!!!\n let func = new Function(\"sheet\", \"survey\", \"return \" + str)\n let ret = func(sheet, survey)\n return ret\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"survey.suggest(question)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":488,"value":"md`### Build your report here\n_Copy code suggestions above and paste them into a new cell below to build up your own custom report._ \n\n_The chart suggestions are made based on a combination of the [question type](https://observablehq.com/@data-workflows/survey-library#types) and data visualization best practices. _\n
\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":812,"value":"meh = survey.histogram(sheet.questions.what_city_do_you_live_in_, { \n limit: 8,\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1023,"value":"mehV = meh.value.selected","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1002,"value":" viewof seqQ = survey.questionSelector(remixSheet, {startIndex: 0, maxSelections: 1})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1026,"value":"f2 = {\n if (seqQ === null) return md`**Select a question to see a visualization.**`;\n let str = survey.serveQuestion(seqQ).code;\n // this is super shady!!!!!!!\n let func = new Function(\n \"remixSheet\",\n \"survey\",\n \"return \" + str.replace(\"sheet.\", \"remixSheet.\")\n );\n let ret = func(remixSheet, survey);\n return ret;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1013,"value":"survey.serveQuestion(seqQ).code.replace(\"sheet.\", \"remixSheet.\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1009,"value":"remixSheet = { \n \n const {data, questions, multiseparator} = sheet\n\n return {mehV, questions, multiseparator}\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"$2d","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 *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":955,"value":"md `---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1050,"value":"d3.csv(\n \"https://docs.google.com/spreadsheets/d/e/2PACX-1vS0Gy9RXOxFDpA233k88HJ6hpewVbFqu0Fu0zA0L_qaX6m2XoGqCGvNIQ6-AG9cRaHPLA_22MVrNWzw/pub?gid=1986684459&single=true&output=csv\"\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":959,"value":"md `## Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":961,"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":965,"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":4,"value":"import {survey} from \"@observablehq/survey-library\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2e","stdlib":"1","titling":"auto"}} 2c:"$2b:body"