[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_109":110,"_111":112},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","khxu","name","presentation-survey","path","backend/aggregate.ts","project",{"_22":48,"_11":12,"_35":49,"_50":-5,"_51":44,"_52":53,"_54":53,"_55":56,"_57":-5,"_58":59,"_60":61,"_62":34,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":44},"file",{"_22":23,"_11":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/khxu/presentation-survey/code/backend/aggregate.ts","extension","id","e694b9d2-763a-458c-8d06-ddb9987b8267","aggregate.ts","fileId","74966aa8-a8eb-11f1-948a-1607ee4eb77e","parentId","a73fa0d1-3dea-4570-b0fc-54f92da89dd6","branchId","00e09eca-4d1b-4e02-b98f-8565c54b4542","branchVersion",146,"latest",true,"createdAt",["D",1788849921426],"version",4,"fileType","script","content","import type {\n Answers,\n FacetGroup,\n IRVRound,\n MatrixAnswer,\n Question,\n QuestionAggregate,\n Survey,\n} from \"../shared/types.ts\";\nimport {\n canonicalizeChoiceSelection,\n matrixAnswerCell,\n matrixCellKey,\n normalizeMatrixAnswer,\n} from \"../shared/questions.ts\";\n\n/** Instant-runoff voting: returns each round's tallies until a majority winner emerges. */\nexport function instantRunoff(\n ballots: string[][],\n optionIds: string[],\n): IRVRound[] {\n const rounds: IRVRound[] = [];\n let remaining = new Set(optionIds);\n const valid = ballots.filter((b) => b.length > 0);\n if (valid.length === 0) return rounds;\n\n for (let round = 1; round <= optionIds.length; round++) {\n const tallies: Record = {};\n for (const id of remaining) tallies[id] = 0;\n let active = 0;\n for (const b of valid) {\n const top = b.find((id) => remaining.has(id));\n if (top) {\n tallies[top]++;\n active++;\n }\n }\n if (active === 0) break;\n const sorted = [...remaining].sort((a, b) => tallies[b] - tallies[a]);\n const leader = sorted[0];\n if (tallies[leader] * 2 > active || remaining.size <= 1) {\n rounds.push({ round, tallies, eliminated: null, winner: leader });\n break;\n }\n // Eliminate the lowest (ties: eliminate the one appearing later in option order)\n const minVal = Math.min(...[...remaining].map((id) => tallies[id]));\n const losers = [...remaining].filter((id) => tallies[id] === minVal);\n const eliminated = losers[losers.length - 1];\n remaining.delete(eliminated);\n rounds.push({\n round,\n tallies,\n eliminated,\n winner: remaining.size === 1 ? [...remaining][0] : null,\n });\n if (remaining.size === 1) break;\n }\n return rounds;\n}\n\nconst STOP = new Set(\n \"the a an and or but of to in on for with is are was were be it this that i you we they my our your\"\n .split(\" \"),\n);\n\nexport function aggregateQuestion(\n q: Question,\n responses: Answers[],\n): QuestionAggregate {\n const vals = responses.map((r) => r[q.id]).filter((v) =>\n v !== undefined && v !== null && v !== \"\"\n );\n const agg: QuestionAggregate = {\n questionId: q.id,\n type: q.type,\n responseCount: vals.length,\n };\n\n switch (q.type) {\n case \"single_choice\":\n case \"emoji_reaction\": {\n const counts: Record = {};\n for (const o of q.options) counts[o.id] = 0;\n for (const v of vals) {\n if (typeof v === \"string\" && v in counts) counts[v]++;\n }\n agg.counts = counts;\n break;\n }\n case \"multi_choice\": {\n const counts: Record = {};\n for (const o of q.options) counts[o.id] = 0;\n const combinations = new Map<\n string,\n { optionIds: string[]; count: number }\n >();\n let responseCount = 0;\n for (const v of vals) {\n const optionIds = canonicalizeChoiceSelection(q.options, v);\n if (!optionIds) continue;\n responseCount++;\n for (const id of optionIds) counts[id]++;\n const key = JSON.stringify(optionIds);\n const combination = combinations.get(key);\n if (combination) combination.count++;\n else combinations.set(key, { optionIds, count: 1 });\n }\n const optionIndex = new Map(\n q.options.map((option, index) => [option.id, index]),\n );\n const compareOptionIds = (a: string[], b: string[]) => {\n if (a.length === 0 || b.length === 0) {\n return a.length === b.length ? 0 : a.length === 0 ? 1 : -1;\n }\n for (let i = 0; i < Math.min(a.length, b.length); i++) {\n const difference = optionIndex.get(a[i])! - optionIndex.get(b[i])!;\n if (difference) return difference;\n }\n return a.length - b.length;\n };\n agg.counts = counts;\n agg.intersections = [...combinations.values()].sort((a, b) =>\n b.count - a.count || compareOptionIds(a.optionIds, b.optionIds)\n );\n agg.responseCount = responseCount;\n break;\n }\n case \"scale\": {\n const min = q.scaleMin ?? 1, max = q.scaleMax ?? 5;\n const dist: Record = {};\n for (let i = min; i <= max; i++) dist[String(i)] = 0;\n let sum = 0, n = 0;\n for (const v of vals) {\n const num = Number(v);\n if (Number.isFinite(num)) {\n dist[String(num)] = (dist[String(num)] ?? 0) + 1;\n sum += num;\n n++;\n }\n }\n agg.distribution = dist;\n agg.mean = n ? Math.round((sum / n) * 100) / 100 : null;\n break;\n }\n case \"free_text\": {\n agg.texts = vals.filter((v): v is string => typeof v === \"string\").slice(\n -200,\n ).reverse();\n break;\n }\n case \"word_cloud\": {\n const freq = new Map();\n const display = new Map();\n for (const v of vals) {\n if (typeof v !== \"string\") continue;\n const key = v.trim().toLowerCase();\n if (!key || STOP.has(key)) continue;\n freq.set(key, (freq.get(key) ?? 0) + 1);\n if (!display.has(key)) display.set(key, v.trim());\n }\n agg.words = [...freq.entries()]\n .map(([k, value]) => ({ text: display.get(k)!, value }))\n .sort((a, b) => b.value - a.value)\n .slice(0, 80);\n break;\n }\n case \"ranked_choice\": {\n const ballots = vals.filter((v): v is string[] => Array.isArray(v));\n const ids = q.options.map((o) => o.id);\n agg.irv = instantRunoff(ballots, ids);\n const borda: Record = {};\n const first: Record = {};\n for (const id of ids) borda[id] = 0, first[id] = 0;\n const n = ids.length;\n for (const b of ballots) {\n b.forEach((id, i) => {\n if (id in borda) borda[id] += n - i;\n });\n if (b[0] && b[0] in first) first[b[0]]++;\n }\n agg.borda = borda;\n agg.firstChoice = first;\n break;\n }\n case \"matrix_2x2\": {\n const size = q.matrixSize ?? 2;\n const counts: Record = {};\n for (let row = 0; row < size; row++) {\n for (let column = 0; column < size; column++) {\n counts[matrixCellKey(row, column)] = 0;\n }\n }\n let validCount = 0;\n const points: MatrixAnswer[] = [];\n for (const value of vals) {\n const answer = normalizeMatrixAnswer(value, size);\n if (!answer) continue;\n const cell = matrixAnswerCell(answer, size);\n counts[matrixCellKey(cell.row, cell.column)]++;\n points.push(answer);\n validCount++;\n }\n agg.responseCount = validCount;\n agg.matrixCounts = counts;\n agg.matrixPoints = points;\n break;\n }\n }\n return agg;\n}\n\n/** Build faceted results. groupBy is a demographic question id (or null for a single \"all\" group). */\nexport function buildResults(\n survey: Survey,\n responses: Answers[],\n groupBy: string | null,\n visibleQuestions: Question[],\n): FacetGroup[] {\n const facetQ = groupBy\n ? survey.questions.find((q) => q.id === groupBy && q.isDemographic)\n : undefined;\n if (!facetQ) {\n return [{\n key: \"__all__\",\n label: \"Everyone\",\n responseCount: responses.length,\n aggregates: visibleQuestions.map((q) => aggregateQuestion(q, responses)),\n }];\n }\n\n // Bucket respondents. Multi-choice facets put a respondent in every group they chose.\n const buckets = new Map();\n const labels = new Map();\n if (facetQ.type === \"scale\") {\n const min = facetQ.scaleMin ?? 1, max = facetQ.scaleMax ?? 5;\n for (let i = min; i <= max; i++) {\n buckets.set(String(i), []), labels.set(String(i), String(i));\n }\n } else {\n for (const o of facetQ.options) {\n buckets.set(o.id, []), labels.set(o.id, o.label);\n }\n }\n buckets.set(\"__none__\", []);\n labels.set(\"__none__\", \"No answer\");\n\n for (const r of responses) {\n const v = r[facetQ.id];\n if (v === undefined || v === null || v === \"\") {\n buckets.get(\"__none__\")!.push(r);\n } else if (Array.isArray(v)) {\n let placed = false;\n for (const x of v) {\n if (buckets.has(x)) buckets.get(x)!.push(r), placed = true;\n }\n if (!placed) buckets.get(\"__none__\")!.push(r);\n } else {\n const k = String(v);\n (buckets.get(k) ?? buckets.get(\"__none__\")!).push(r);\n }\n }\n\n const groups: FacetGroup[] = [];\n for (const [key, rs] of buckets) {\n if (key === \"__none__\" && rs.length === 0) continue;\n groups.push({\n key,\n label: labels.get(key) ?? key,\n responseCount: rs.length,\n aggregates: visibleQuestions.filter((q) => q.id !== facetQ.id).map((q) =>\n aggregateQuestion(q, rs)\n ),\n });\n }\n return groups;\n}\n","deleted",false,"label",[47,24],"backend","ae520107-1d25-47b9-ad83-831e36befb67",["D",1788585574393],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Live talk polling: QR join, ranked choice, demographic facets","imageUrl","userId","0198fc74-a2ac-77df-bbdc-e23a8e395bee","pinnedFileId","01a0700e-6ffa-7369-be27-ef5029df6316","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","0198fc74-a2ad-7019-840f-e164a0170dfc","tursoName","ae5201071d2547b9ad83831e36befb67","tursoHostname","ae5201071d2547b9ad83831e36befb67-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789542098478],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_108":104},"org",{"_9":10,"_102":-5,"_103":104,"_58":59,"_105":106,"_107":44},"branch",{"_37":92,"_11":93,"_22":30,"_94":48,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":12,"_101":10},"isOwned",150,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zMjFKVFdGYXdiZmFXS0hOajdwWHNBOUlZUE4ifQ","tier","pro","canRestrictVals","profileImageUrl","ctx",{"_85":-5,"_142":143,"_144":145,"_146":147,"_148":44,"_149":44,"_150":44,"_151":34,"_152":-5,"_153":-7,"_154":-7,"_155":66,"_156":44,"_157":44,"_158":-5,"_159":44,"_160":44,"_161":44,"_162":-5},"ENV",{"_113":114,"_115":116,"_117":93,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139,"_140":141},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]