2e:null 2f:["$","title",null,{"children":"Panopticon user vitals | palimpsest | Observable"}] 34:[] 32:{"id":"8c3a00638d91cf89","slug":"user-vitals","title":"Panopticon user vitals","thumbnail":"bd5a7cb7fd1ebd544ecf468b36d55c5f3123bbb8d0dccd4d7fedbdc231c74280","access_level":"public","create_time":"$D2023-06-14T14:15:56.651Z","update_time":"$D2025-07-01T11:51:05.092Z","view_time":null,"first_public_time":"$D2023-06-14T14:15:56.651Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"5a0b9ab3ecb02e40","login":"palimpsest","name":"palimpsest","avatar_url":"https://avatars-next.observableusercontent.com/1a685fbd1b98ef5b1d2558da08b6e55946d4df957c4746fbf934c42c2984240a","tier":"starter_2024"},"version":207,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"5ee139d907a161d7","login":"palimpsest","name":"palimpsest","avatar_url":"https://avatars-next.observableusercontent.com/1a685fbd1b98ef5b1d2558da08b6e55946d4df957c4746fbf934c42c2984240a","tier":null}],"members":[{"type":"individual","id":"5ee139d907a161d7","login":"palimpsest","name":"palimpsest","avatar_url":"https://avatars-next.observableusercontent.com/1a685fbd1b98ef5b1d2558da08b6e55946d4df957c4746fbf934c42c2984240a","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"9b47debcc62db90b","slug":"poc-tools","title":"POC Tools","owner":{"id":"5a0b9ab3ecb02e40","login":"palimpsest","name":"palimpsest"}},"type":"notebook","body":{"title":"Panopticon user vitals","cells":[{"id":0,"value":"# Panopticon user vitals\n\nLooks for user posts (replies) and comments (notes) in database. \nLooks in results for 2023 first then goes through archive 2022 to 2020.\n\n**There are no notes in the data for 2021**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":15,"value":"viewof search = Inputs.text({label: \"Search\", submit:true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":133,"value":"Latest post : ${new Date(resultReplies[0].date)}\n
\nEarliest post : ${new Date(resultReplies.slice(-1)[0].date)}","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":154,"value":"html `${latestReplies}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":152,"value":"latestReplies = resultReplies.slice(0, 20).map(value => displayReply(value));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"## Latest results (2023-current year) \nIf result arrays are empty user hasn't posted or commented since 2023. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":119,"value":"data = resultReplies","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"data","database":"$undefined"},{"id":200,"value":"## Top topics","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":193,"value":"Plot.plot({\n marginLeft: 220,\n x: {\n grid: true,\n label: \"Count\"\n },\n y: {\n label: null\n },\n marks: [\n Plot.barX(processDataForPlot, {\n y: \"topicTitle\",\n x: \"count\",\n sort: {y: \"-x\"},\n fill: d => d.topicTitle.startsWith(\"Others\") ? \"#808080\" : \"steelblue\" // Different color for Others\n }),\n Plot.ruleX([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":202,"value":"## Votes on replies","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":124,"value":"Plot.plot({\n marks: [\n Plot.auto(data, {x: \"score\"})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":188,"value":"processDataForPlot = getTopTopics(resultReplies);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":178,"value":"function getTopTopics(data){\n const counts = getCounts(data);\n\n \n // Convert to array and sort by count\n let sortedEntries = Object.entries(counts)\n .map(([topicTitle, count]) => ({topicTitle, count}))\n .sort((a, b) => b.count - a.count);\n \n // Get top 20\n const top10 = sortedEntries.slice(0, 20);\n \n // Sum up the rest for \"Others\"\n const othersCount = sortedEntries.slice(10)\n .reduce((sum, item) => sum + item.count, 0);\n \n // Add Others if there are any\n if (othersCount > 0) {\n top10.push({\n topicTitle: `Others (${sortedEntries.length - 20} topics)`,\n count: othersCount\n });\n }\n \n return top10;\n\n};","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"resultReplies = searchRepliesIn2023()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"resultNotes = searchNotesIn2023()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":80,"value":"## Archive results \nLooking for user in 2022, 2021 and 2020 posts (replies) and comments (notes). Returns first occurrence in archive year.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":82,"value":"archiveResults = searchInArchive()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"## Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":72,"value":"archive = [{replies: replies2022, notes:notes2022}, {replies:replies2021, notes:notes2021}, {replies:replies2020, notes:notes2020}]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"replies2023 = getAllReplies()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"notes2023 = getNotesFlat(replies2023)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"replies2022 = replies","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":62,"value":"notes2022 = getNotesFlat(replies2022)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"replies2021 = replies_2021","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"notes2021 = getNotesFlat(replies2021)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"replies2020 = replies_2020","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"notes2020 = getNotesFlat(replies2020)\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"## Functions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":185,"value":"function getCounts(data){\n const counts = {};\n data.forEach(d => {\n counts[d.topicTitle] = (counts[d.topicTitle] || 0) + 1;\n });\n return counts;\n};","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"function searchInArchive(){\n for(let i=0; i String(v.user).toLowerCase() == search.trim().toLowerCase()).reverse()\n if(repliesResult.length > 0){\n return repliesResult\n }\n const notesResult = notes.filter(v => v.user.toLowerCase() == search.trim().toLowerCase()).reverse()\n if(notesResult.length > 0){\n return notesResult\n }\n }\n return []\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"function searchRepliesIn2023(){\n return replies2023.filter(v => v.user.toLowerCase() == search.trim().toLowerCase()).reverse()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"function searchNotesIn2023(){\n return notes2023.filter(v => v.user.toLowerCase() == search.trim().toLowerCase()).reverse()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"function displayReply(value) {\n const date = value.published\n let output = '

'\n output += \"

\" + value.user + \"

\"\n output += ''\n output += date.toUTCString()\n output += ''\n output += '

' + value.topicTitle + '

'\n\n output += '

'\n output += value.post //mp4UrlToVideoEmbed(value.post)\n output += \"

Score: \" + value.score + \"

\"\n output += \"

Notes

\"\n output += value.notes.map(v => \"\"+v.user + \": \" + v.comment + \" \").join(\" | \")\n return output\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":161,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"## Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":7,"value":"import {getAllReplies} from \"be1c16dba078b46e\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"import {replies, replies_2021, replies_2020} from \"1de6ee6f485fd1e3\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"import {getNotesFlat} from \"1de6ee6f485fd1e3\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 33:"$32:body"