31:T4aa,{ let weeks = {} return vegalite({ data: { values: candidates .map(c => { let sign = Math.sign(c.decisionIndex - 4.5) let key = [c.cohort_week, sign] weeks[key] = weeks[key] || [] return _.merge({ cohort_week_i: sign * weeks[key].push(c) }, c) }) }, width: width - 50, mark: { type: 'text', align: 'left', dx: 4, dy: 4, }, encoding: { text: {field: 'name'}, href: {field: 'urls.show'}, x: { field: 'cohort_week', type: 'temporal', axis: {orient: 'top', tickCount: 11}, }, y: { field: 'cohort_week_i', type: 'ordinal', scale: {rangeStep: 18}, axis: false }, color: { field: 'decision', type: 'nominal', legend: false, //{orient: 'left'}, scale: { domain: decisions.map(r => r[0]), range: decisions.map(r => r[1]), } }, size: { field: 'onsite', type: 'nominal', scale: { domain: ['false', 'true'], range: [8, 10], }, legend: false }, } }) }32:[] 2f:{"title":"Candidates per week","cells":[{"id":0,"value":"md`# Candidates per week\nCandidates by week of interview (phone screen or later).\nData from the Lever API.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1151,"value":"viewof department = html`\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1171,"value":"viewof posting = html`\n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":928,"value":"viewof show = html`\n \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1009,"value":"viewof date = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":63,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":836,"value":"vegalite({\n data: {values: candidates},\n layer: [{\n mark: 'bar',\n encoding: {\n y: {field: 'decision', type: 'ordinal'}, //, scale: {domain: decisions.map(d => d[0])}},\n x: {aggregate: 'count'},\n color: {field: 'decision', type: 'ordinal', scale: {domain: decisions.map(d => d[0]), range: decisions.map(d => d[1])}, legend: false},\n opacity: {field: 'onsite', type: 'nominal', scale: {domain: ['false', 'true'], range: [0.4, 1]}, legend: false},\n }\n }, {\n mark: {type:'text', dx: 8, dy: 4},\n encoding: {\n y: {field: 'decision', type: 'ordinal', scale: {domain: decisions.map(d => d[0])}},\n x: {aggregate: 'count'},\n text: {aggregate: 'count'},\n }\n }]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":45,"value":"candidates = {\n const domain = [d3.timeWeek.offset(date, -12), new Date(date)]\n \n return _.chain(query.rows)\n .filter(c => {\n c.cohort_at = cohortAt(c)\n c.cohort_week = d3.timeWeek(c.cohort_at)\n return domain[0] <= c.cohort_week && c.cohort_week <= domain[1]\n })\n .filter(c => posting === \"\" || _.includes(c.postings, posting))\n .forEach(c => {\n c.name = name(c.name)\n c.onsite = c.stage_changes[c.stage_changes.length - 1].toStageIndex >= 7\n c.decision = c.archived || c.stage\n c.decisionIndex = _.findIndex(decisions, r => c.decision === r[0])\n })\n .filter(c => {\n switch (show) {\n case 'on-sites':\n return c.onsite\n case 'phone screens':\n return !c.onsite\n default:\n return true\n }\n })\n .sortBy('decisionIndex', 'onsite', 'id')\n .value()\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":432,"value":"viewof query = lever(`\n select\n c.id,\n c.name,\n c.stage_changes,\n c.archived,\n c.stage,\n c.urls,\n s.text as stage,\n ar.text as archived,\n jsonb_agg(p.text) as postings\n from candidates c\n join stages s on s.id = c.stage\n left join archive_reasons ar on ar.id = (c.archived->>'reason')::uuid\n join applications a on a.candidate = c.id\n join postings p on a.posting = p.id\n where p.categories->>'department' = '${department}'\n group by c.id, c.name, c.stage_changes, c.archived, c.stage, c.urls, s.text, ar.text\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":389,"value":"function cohortAt(candidate) {\n let i = _.findLastIndex(candidate.stage_changes, s => s.toStageIndex < 5),\n stage = candidate.stage_changes[i+1]\n return stage ? new Date(stage.updatedAt) : new Date\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":626,"value":"decisions = [\n ['Offer', '#a1d76a'],\n ['Hired', '#4d9221'],\n ['On-site interview', 'black'],\n ['Phone Interview', 'gray'],\n ['Assignment', 'lightgray'],\n ['Offer declined', '#c51b7d'],\n ['Withdrew', '#e9a3c9'],\n ['Underqualified',\t'lightgray'],\n ['Timing',\t\t\t'lightgray'],\n ['Unresponsive',\t\t'lightgray'],\n ['Historical Candidates', 'lightgray'],\n ['Cleanup', 'lightgray'],\n ['Position closed', 'lightgray'],\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":1077,"value":"_.difference(_.uniq(_.map(candidates, 'decision')), decisions.map(d => d[0]))","pinned":false,"hidden":false,"mode":"ojs"},{"id":477,"value":"function name(fullName) {\n return fullName.split(' ').map((s, i) => i === 0 ? s : s[0]).join(' ')\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1164,"value":"viewof postings = lever(`\n select text\n from postings\n where categories->>'department' = '${department}'\n and state != 'closed'\n order by text\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":260,"value":"_ = require('lodash')","pinned":false,"hidden":false,"mode":"ojs"},{"id":375,"value":"d3 = require('d3')","pinned":false,"hidden":false,"mode":"ojs"},{"id":235,"value":"import { lever, vegalite } from '@visnup/lever'","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}