2b:null 2c:["$","title",null,{"children":"Competitor Salary Overview | Aldo Viramontes | Observable"}] 31:Tcf2,top_salary_comparison = vl.hconcat( // Chart 1 vl.layer( vl.data(rp_top).title( formatter2(second_half_month[0].sh_start) + ' to ' + formatter2(second_half_month[0].sh_end)) .encode( vl.y().fieldN('Company').sort(vl.max('t_mk').order('descending')).title(null) ) .layer( vl.markBar({tooltip: true}) .encode( vl.x().median('salary_extract').title('Median Salary').axis({titleFontWeight: 200, format: '$.0f'}), vl.color({format: '.1%'}).max('t_mk').scale({range: ['#ebebeb',_color]}).legend({orient: 'bottom', format: '.0%', tickCount: 3, gradientThickness: 7, titleFontWeight: 200, labelFontWeight: 100}).title('Market Share') ), vl.markText({color: 'white', dx: -20, size: 10}) .encode( vl.x().median('salary_extract'), vl.text({format: '$.1f'}).median('salary_extract') ) ), vl.layer( // this is the average line for current week vl.markRule({color: myCompany_color_palette[1], strokeWidth: 2}) .data(rp_top) //.data(recent_period) //.data(rp_top) // -- rp_top is the data for the whole market? .encode( vl.x().median('salary_extract') ), vl.markText({fontWeight: 400, dx: 0, angle: 0, color: myCompany_color_palette[1], size: 17, dy: -15}) //dy: -175 .data(rp_top) //.data(recent_period) //.data(rp_top) .encode( vl.x().median('salary_extract'), vl.y().value(-'height'), vl.text({format: '$.2f'}).median('salary_extract') ) ) ).width(form.chart_width), // Chart 2 vl.layer( vl.data(pp_top).title( formatter2(first_half_month[0].fh_start) + ' to ' + formatter2(first_half_month[0].fh_end) ) .encode( vl.y().fieldN('Company').sort(vl.max('t_mk').order('descending')).title(null) ) .layer( vl.markBar({tooltip: true}) .encode( vl.x().median('salary_extract').title('Median Salary').axis({titleFontWeight: 200, format: '$.0f'}), vl.color({format: '.1%'}).max('t_mk').scale({range: ['#616161','#ebebeb'], reverse: true}).legend({tickCount: 3, orient: 'bottom', format: '%', gradientThickness: 7, titleFontWeight: 200, labelFontWeight: 100}).title('Market Share') ), vl.markText({color: 'white', dx: -20, size: 10}) .encode( vl.x().median('salary_extract'), vl.text({format: '$.1f'}).median('salary_extract') ) ), vl.layer( // this is the average line for previous week vl.markRule({color: myCompany_color_palette[1], strokeWidth: 2}) .data(pp_top) //.data(previous_period) //.data(pp_top) .encode( vl.x().median('salary_extract') ), vl.markText({fontWeight: 400, dx: 0, angle: 0, color: myCompany_color_palette[1], size: 17, dy: -15}) //dy: -175 .data(pp_top) //.data(previous_period) //.data(pp_top) .encode( vl.x().median('salary_extract'), vl.y().value(-'height'), vl.text({format: '$.2f'}).median('salary_extract') ) ) ).width(form.chart_width) ) .resolve({scale: {color: 'independent'} }) .spacing(form.chart_spacing) .config(clean_config) .padding({left: 25, top: 50, bottom: 50}) .render()32:Tdd7,market_avg = { const mkt_txt = vl .markText({ size: 55, fontWeight: 100, opacity: 0.7, dx: 100 }) .title({ text: "Market Average (Median)", fontSize: 17, subtitle: formatter2(second_half_month[0].sh_start) + " to " + formatter2(second_half_month[0].sh_end), subtitleFontWeight: 100, subtitleFontSize: 10, subtitlePadding: 7.5, dx: 100 }) .encode(vl.text({ format: "$.2f" }).median("salary_extract")); const mkt_bar = vl .markBar({ tooltip: true, width: { band: 0.8 }, opacity: 0.9, color: appc2_color_scheme[0] }) .encode( vl .x() .fieldQ("salary_extract") .bin({ minstep: 2.5 }) .axis({ format: "$.1d", labelOpacity: 0.5, tickOpacity: 0.3, labelFontWeight: 200, titleFontWeight: 200, titlePadding: 15 }) .title("Salary Range"), vl .y() .count() .title("Number of posts") .axis({ labelOpacity: 0.3, tickOpacity: 0.3, labelFontWeight: 200, titleFontWeight: 200, titlePadding: 20 }) ) .width(form.chart_width - 50); const my_comp_txt = vl .markText({ size: 55, fontWeight: 100, opacity: 0.7, dx: 100 }) .title({ text: "My_Company Average (Median)", fontSize: 17, subtitle: formatter2(second_half_month[0].sh_start) + " to " + formatter2(second_half_month[0].sh_end), subtitleFontWeight: 100, subtitleFontSize: 10, subtitlePadding: 7.5, dx: 100 }) .encode(vl.text({ format: "$.2f"}).median("salary_extract")); const my_comp_bar = vl .markBar({ width: { band: 0.8 }, opacity: 0.9, color: appc2_color_scheme[0] }) .data( recent_period.filter( (d) => !selected_companies_array.includes(d.Company) ) ) .encode( vl .x() .fieldQ("salary_extract") .bin({ minstep: 1 }) .axis({ format: "$.1d", labelOpacity: 0.5, tickOpacity: 0.3, labelFontWeight: 200, titleFontWeight: 200, titlePadding: 15 }) .scale({ padding: 0 }) .title("Salary Range"), vl .y() .count() .title("Number of posts") .axis({ titleFontWeight: 200, labelOpacity: 0.3, tickOpacity: 0.3, labelFontWeight: 200 }) ) .width(form.chart_width - 50); return vl.hconcat( vl.vconcat(mkt_txt, mkt_bar).data(recent_period.filter(d => !selected_companies_array.includes(d.Company))), vl.vconcat(my_comp_txt, my_comp_bar).data(recent_period.filter(d => selected_companies_array.includes(d.Company))) ) .spacing(250) .config(clean_config) .padding({top: 75, bottom: 75, right: 30, left: 30}) .render() }33:T8be,vl.hconcat( // Chart 1 vl.layer( vl.data(rp_top).title('Current Week') .encode( vl.y().fieldN('Company').sort(vl.max('salary_extract').order('descending')) ) .layer( vl.markBar({color: appc2_color_scheme[0]}) .encode( vl.x().median('salary_extract'), //vl.color().fieldQ('t_mk').legend({orient: 'bottom', format: '%'}).title('Market Share') ), vl.markText({color: 'white', dx: -20, size: 10}) .encode( vl.x().median('salary_extract'), vl.text({format: '$.1f'}).median('salary_extract') ) ), vl.layer( // this is the average line for current week vl.markRule({color: 'red'}) .data(rp_top) .encode( vl.x().median('salary_extract') ), vl.markText({angle: 90, dy: -10, color: 'red'}) .data(rp_top) .encode( vl.x().median('salary_extract'), vl.text({format: '$.1f'}).median('salary_extract') ) ) ), // Chart 2 vl.layer( vl.data(pp_top).title('Previous Week') .encode( vl.y().fieldN('Company').sort(vl.max('salary_extract').order('descending')) ) .layer( vl.markBar({color: '#dedede'}) .encode( vl.x().median('salary_extract'), //vl.color().fieldQ('t_mk').scale({range: ['#616161', '#767676', '#8c8c8c', '#a3a3a3', '#bababa', '#d2d2d2', '#ebebeb']}).legend({orient: 'bottom', format: '%'}).title('Market Share') ), vl.markText({color: 'white', dx: -20, size: 10}) .encode( vl.x().median('salary_extract'), vl.text({format: '$.1f'}).median('salary_extract') ) ), vl.layer( // this is the average line for previous week vl.markRule({color: 'red'}) .data(pp_top) .encode( vl.x().median('salary_extract') ), vl.markText({angle: 90, dy: -10, color: 'red'}) .data(pp_top) .encode( vl.x().median('salary_extract'), vl.text({format: '$.1f'}).median('salary_extract') ) ) ) ) .resolve({scale: {color: 'independent'} }) .spacing(50) .config(clean_config) .render()34:Taa3,vl.hconcat( // Chart 1 vl.layer( vl.data(rp_top).title('Current Week') .encode( vl.y().fieldN('Company').sort(vl.max('t_mk').order('descending')).title(null) ) .layer( vl.markBar({tooltip: true}) //{color: appc2_color_scheme[0]}) .encode( vl.x().median('salary_extract').title('Median Salary'), vl.color().max('t_mk').legend({orient: 'bottom', format: '%', gradientThickness: 7, titleFontWeight: 200, labelFontWeight: 100}).title('Market Share') ), vl.markText({color: 'white', dx: -20, size: 10}) .encode( vl.x().median('salary_extract'), vl.text({format: '$.1f'}).median('salary_extract') ) ), vl.layer( // this is the average line for current week vl.markRule({color: myCompany_color_palette[1], strokeWidth: 2}) .data(rp_top) .encode( vl.x().median('salary_extract') ), vl.markText({fontWeight: 400, dx: 0, angle: 0, color: myCompany_color_palette[1], size: 17, dy: -15}) //dy: -175 .data(rp_top) .encode( vl.x().median('salary_extract'), vl.y().value(-'height'), vl.text({format: '$.1f'}).median('salary_extract') ) ) ), // Chart 2 vl.layer( vl.data(pp_top).title('Previous Week') .encode( vl.y().fieldN('Company').sort(vl.max('t_mk').order('descending')).title(null) ) .layer( vl.markBar() ///{color: '#dedede'}) .encode( vl.x().median('salary_extract').title('Median Salary'), vl.color().max('t_mk').scale({range: ['#616161', '#767676', '#8c8c8c', '#a3a3a3', '#bababa', '#d2d2d2', '#ebebeb'], reverse: true}).legend({orient: 'bottom', format: '%', gradientThickness: 7, titleFontWeight: 200, labelFontWeight: 100}).title('Market Share') ), vl.markText({color: 'white', dx: -20, size: 10}) .encode( vl.x().median('salary_extract'), vl.text({format: '$.1f'}).median('salary_extract') ) ), vl.layer( // this is the average line for previous week vl.markRule({color: myCompany_color_palette[1], strokeWidth: 2}) .data(pp_top) .encode( vl.x().median('salary_extract') ), vl.markText({fontWeight: 400, dx: 0, angle: 0, color: myCompany_color_palette[1], size: 17, dy: -15}) //dy: -175 .data(rp_top) .encode( vl.x().median('salary_extract'), vl.y().value(-'height'), vl.text({format: '$.1f'}).median('salary_extract') ) ) ) ) .resolve({scale: {color: 'independent'} }) .spacing(50) .config(clean_config) .render()35:Ta8d,vl.hconcat( // Chart 1 vl.layer( vl.data(rp_top).title('Current Week') .encode( vl.y().fieldN('Company').sort(vl.max('t_mk').order('descending')).title(null) ) .layer( vl.markBar({tooltip: true}) //{color: appc2_color_scheme[0]}) .encode( vl.x().median('salary_extract').title('Median Salary'), vl.color().max('t_mk').scale({range: ['#ebebeb',_color]}).legend({orient: 'bottom', format: '%', gradientThickness: 7, titleFontWeight: 200, labelFontWeight: 100}).title('Market Share') ), vl.markText({color: _color, dx: 20, size: 10}) .encode( vl.x().median('salary_extract'), vl.text({format: '$.1f'}).median('salary_extract') ) ), vl.layer( // this is the average line for current week vl.markRule({color: myCompany_color_palette[1], strokeWidth: 2}) .data(rp_top) .encode( vl.x().median('salary_extract') ), vl.markText({fontWeight: 400, dx: 0, angle: 0, color: myCompany_color_palette[1], size: 17, dy: -15}) //dy: -175 .data(rp_top) .encode( vl.x().median('salary_extract'), vl.y().value(-'height'), vl.text({format: '$.1f'}).median('salary_extract') ) ) ), // Chart 2 vl.layer( vl.data(pp_top).title('Previous Week') .encode( vl.y().fieldN('Company').sort(vl.max('t_mk').order('descending')).title(null) ) .layer( vl.markBar() ///{color: '#dedede'}) .encode( vl.x().median('salary_extract').title('Median Salary'), vl.color().max('t_mk').scale({range: ['#616161','#ebebeb'], reverse: true}).legend({orient: 'bottom', format: '%', gradientThickness: 7, titleFontWeight: 200, labelFontWeight: 100}).title('Market Share') ), vl.markText({color: '#616161', dx: 20, size: 10}) .encode( vl.x().median('salary_extract'), vl.text({format: '$.1f'}).median('salary_extract') ) ), vl.layer( // this is the average line for previous week vl.markRule({color: myCompany_color_palette[1], strokeWidth: 2}) .data(pp_top) .encode( vl.x().median('salary_extract') ), vl.markText({fontWeight: 400, dx: 0, angle: 0, color: myCompany_color_palette[1], size: 17, dy: -15}) //dy: -175 .data(rp_top) .encode( vl.x().median('salary_extract'), vl.y().value(-'height'), vl.text({format: '$.1f'}).median('salary_extract') ) ) ) ) .resolve({scale: {color: 'independent'} }) .spacing(50) .config(clean_config) .render()36:[] 2f:{"id":"039d3169073479c3","slug":null,"title":"Competitor Salary Overview","thumbnail":"c5fb8733b625f35992e0e59734c06ab8bb2055941b2f58fd7729831d80bce37f","access_level":"public","create_time":"$D2022-11-16T19:16:12.175Z","update_time":"$D2022-11-17T14:40:03.537Z","view_time":null,"first_public_time":"$D2022-11-16T19:16:12.175Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"5f951abbf0f9a9aa","login":"aldo","name":"Aldo Viramontes","avatar_url":"https://avatars-next.observableusercontent.com/3578940c18624eca7abf032e1f8fd167831daefdc6f5eb3b769dfa62c5672a8e","tier":"starter_2024"},"version":2185,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"2c829f0156fadf01","login":"aldo","name":"Aldo Viramontes","avatar_url":"https://avatars-next.observableusercontent.com/3578940c18624eca7abf032e1f8fd167831daefdc6f5eb3b769dfa62c5672a8e","tier":null}],"members":[{"type":"individual","id":"2c829f0156fadf01","login":"aldo","name":"Aldo Viramontes","avatar_url":"https://avatars-next.observableusercontent.com/3578940c18624eca7abf032e1f8fd167831daefdc6f5eb3b769dfa62c5672a8e","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Competitor Salary Overview","cells":[{"id":0,"value":"title6 = md `# Competitor Salary Overview`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1213,"value":"break4 = html `
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1216,"value":"title1 = md `### Competitive Intelligence - Master File`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":781,"value":"viewof file = Inputs.file({label: \"Load data\", required: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1351,"value":"data_requirement = md `*The tool assumes the file contains dates corresponding to a 4-week window*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":796,"value":"req_date_range_text = md `Date range for the file you have loaded: **${formatter(date_range[0])}** to **${formatter(date_range[1])}**`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":785,"value":"break1 = html `

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2053,"value":"md `## Background\n
\n\nSuppose that a company has a dataset where each observation provides information about its competitors job posts. In this data set you find the job title, the hourly salary offer, the location (both as an airport code as well as a zip code) and the date of the job post.\n\nIn order to gain a competitive advantage, the company can generate a quick overview by geographic area (in this case, an airport code) on how the market's top competitors are offering, for instance, its salary.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2057,"value":"md `
\n## Filter to a specific Geographic Area`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2063,"value":"html `
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":792,"value":"viewof node_selector = Inputs.select(data.map(d => d.Node), {label: \"Select a Node\", unique: true, sort: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":788,"value":"title2 = md `
\n## Median Salary for Top Market Share Holders\n
\n\nIn the two charts below, we present a summary of the median salary for each company, as well as an overall median salary for two time periods. In addition to that, the color encoding provides the market share that each company currently holds`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1157,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1312,"value":"title5 = md `**_Control Panel for Salary Charts_**`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2026,"value":"viewof form = Inputs.form({\n chart_spacing: Inputs.range([0, 300], {label: \"chart spacing\", step: 5, value: 75}),\n chart_width: Inputs.range([0, 600], {label: \"chart width\", step: 5, value: 200})\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1196,"value":"break3 = html `

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1199,"value":"title3 = md `# My Company\n### Node Salary Distribution and Full Market Average\n
\n\nIn addition to the overview of the top competitors, we can also get an overview of the full market vs. our company by visualizing the data as a distribution of the salary by post`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2085,"value":"viewof search = Inputs.search(\n aq.from(recent_period)\n .select('Company')\n .dedupe()\n .objects()\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2088,"value":"viewof selected_companies = Inputs.table(search, {\n columns: ['Company'],\n width: 650,\n value: search.slice(0,2)\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":688,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1496,"value":"title7 = md `
\n## My_Company vs Market Median Salary over time`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2181,"value":"aq.from(selected_companies).view()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1411,"value":"over_time = vl.layer(\n \n // vl.markErrorbar()\n // .encode(\n // vl.x().fieldT('date'),\n // vl.y().fieldQ('salary_extract'),\n // //vl.opacity().value(0.1)\n // ),\n \n vl.markLine({tooltip: true, strokeWidth: 1.5, \n point: { \n size: 50, \n stroke: 'white'\n }})\n .encode(\n vl.x().fieldT('date').axis({grid: true, tickCount: 10}).title(null),\n vl.y().median('salary_extract')\n .scale({padding: 20, zero: true})\n .title('Median Salary')\n .axis({\n format: '$', \n labelOpacity: 0.5, \n titleFontWeight: 200,\n titlePadding: 15}),\n vl.color().fieldN('my_company')\n .scale({range: [myCompany_color_palette[4], '#cccccc'], domain: ['My Company', 'Market']})\n .legend({title: 'Company'})\n )\n )\n .data(clean_week_split)\n .width(width - 300)\n .config(clean_config)\n .padding({top: 50, bottom: 20})\n .render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":88,"value":"break5 = html `
\n
\n
\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"md `## Appendix\n\n_Implementation & data stuff_`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2121,"value":"selected_companies_array = selected_companies.map(d => d.Company)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":198,"value":"### *Data*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":538,"value":"Inputs.table(clean_week_split)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1229,"value":"// instead of this week vs previous week, the split is at first vs second half of a month back\n// this code looks at the first half\n\nfirst_half_month = aq.from(clean_week_split)\n .select('date', 'Segment')\n .orderby(0)\n .dedupe()\n .filter(d => d.Segment == 'first_half')\n .derive({\n fh_start: d => op.min(d.date),\n fh_end: d => op.max(d.date)\n })\n .select('fh_start', 'fh_end')\n .dedupe()\n .objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1269,"value":"// instead of this week vs previous week, the split is at first vs second half of a month back\n// this code looks at the second half\n\nsecond_half_month = aq.from(clean_week_split)\n .select('date', 'Segment')\n .orderby(0)\n .dedupe()\n .filter(d => d.Segment == 'second_half')\n .derive({\n sh_start: d => op.min(d.date),\n sh_end: d => op.max(d.date)\n })\n .select('sh_start', 'sh_end')\n .dedupe()\n .objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":482,"value":"//cleaned up for salary manipulation by week\n\nclean_week_split = aq.from(data_nodeFL)\n .derive({date: d => op.parse_date(d.Date)}, {before: 'Rank'})\n .derive({\n first_half: aq.escape(d => d.date <= two_weeks_back)\n })\n .derive({\n second_half: aq.escape(d => d.date > two_weeks_back)\n })\n .fold(['first_half','second_half'], {as: ['Segment', 'Value']})\n .filter(d => d.Value === true)\n .filter(d => d.salary_extract > 0)\n .derive({my_company: d => d.Company == 'UPS' ? 'My Company' : 'Market'})\n .objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":807,"value":"data_nodeFL = data.filter(d => d.Node == node_selector)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":394,"value":"data = file.csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":916,"value":"### By 2 week period","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":990,"value":"*Recent 2 Weeks*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1756,"value":"#### Node level","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":920,"value":"viewof recent_period = Inputs.table(aq.from(clean_week_split) \n .filter(d => d.Segment == 'second_half') \n .groupby('date', 'Company','Segment', 'salary_extract')\n .count() \n .groupby('Segment') \n .derive({market_share: d => d.count/op.sum(d.count)})\n .orderby(aq.desc('market_share')) \n .objects())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":979,"value":"rp_top = aq.from(recent_period)\n .groupby('Company', 'salary_extract')\n .rollup({\n median_salary: d => op.median(d.salary_extract),\n t_ct: d => op.sum(d.count),\n t_mk: d => op.sum(d.market_share)\n })\n .orderby(aq.desc('t_mk'))\n .filter(d => op.rank() <= 20)\n .objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1002,"value":"cw_list = aq.from(rp_top)\n .select('Company')\n .objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1010,"value":"cw_list2 = companies(cw_list)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1013,"value":"cw_list3 = cw_list2.Company","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1760,"value":"#### Multi site level","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":994,"value":"*Previous 2 Weeks*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1776,"value":"#### Node level","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":932,"value":"viewof previous_period = Inputs.table(aq.from(clean_week_split) \n .filter(d => d.Segment == 'first_half')\n .groupby('date', 'Company','Segment', 'salary_extract')\n .count()\n .groupby('Segment')\n .derive({market_share: d => d.count/op.sum(d.count)})\n .orderby(aq.desc('market_share')) \n .objects())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1015,"value":"pp_top = aq.from(previous_period)\n .groupby('Company', 'salary_extract')\n .rollup({\n t_ct: d => op.sum(d.count),\n t_mk: d => op.sum(d.market_share)\n })\n .orderby(aq.desc('t_mk'))\n .filter(d => op.rank() <= 20)\n .objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1019,"value":"pw_list = aq.from(pp_top)\n .select('Company')\n .objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1022,"value":"pw_list2 = companies(pw_list)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1024,"value":"pw_list3 = pw_list2.Company","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1742,"value":"#### Multi site level","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":402,"value":"#### Date","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":573,"value":"formatter = d3.timeFormat('%d %B %Y')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1282,"value":"formatter2 = d3.timeFormat('%A %b %d, %Y')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":424,"value":"data_date_range = aq.from(data)\n .derive({date: d => op.parse_date(d.Date)}, {before: 'Rank'})\n .objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":412,"value":"date_range = d3.extent(data_date_range, d => d.date)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":415,"value":"two_weeks_back = d3.timeDay.offset(date_range[1], -14)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":193,"value":"### *Libraries*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":4,"value":"import {vl} from '@vega/vega-lite-api-v5'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"import {uniqueValid} from '@uwdata/data-utilities'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":59,"value":"import { aq, op } from '@uwdata/arquero'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":139,"value":"// object containing all of the FIPS us state codes\n\nimport {statemap} from \"@d3/choropleth\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":137,"value":"// object containing all of the FiPS us county codes\n\nimport {counties} from \"@d3/choropleth\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":151,"value":"import {countyShapes} from \"@enjalot/us-county-datasets\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":159,"value":"//example to use the file above\ncountyShapes.features[0].properties.name","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":208,"value":"### *Chart configuration*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1154,"value":"viewof _color = Inputs.select(myCompany_color_palette, {label: \"Select a color\", value: myCompany_color_palette[4]})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1088,"value":"myCompany_color_palette = ['#3138BB', '#FF7D6F', '#AF9BFC', '#C7FFE2', '#127FFC', '#FF9B77', '#FAFAFA']","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":457,"value":"appc2_color_scheme = ['#127ffc', '#d3d3d3']","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":202,"value":"clean_config = ({\n view: { stroke: null },\n axis: {\n gridOpacity: 0.5,\n labelFontWeight: 75,\n domain: false,\n offset: 5,\n titleFontWeight: 350,\n titleFontSize: 10,\n //labelOpacity: 0.3,\n tickOpacity: 0.3\n },\n axisX: {\n grid: false,\n tickCount: 5,\n titlePadding: 10,\n labelPadding: 4,\n labelOpacity: 0.5\n },\n axisY: {\n ticks: false,\n labelLimit: 300,\n labelFontSize: 9,\n titlePadding: 10\n },\n title: {\n fontWeight: 300,\n fontSize: 13,\n offset: 25\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":811,"value":"### *Visualization Iterations*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":614,"value":"vl.layer(\n \n vl.markSquare({color: appc2_color_scheme[0], size: 350})\n .encode(\n vl.x().fieldT('date').scale({padding: 20}),\n vl.y().fieldQ('salary_extract').scale({padding: 20}).bin(true),\n vl.opacity().count().scale({range: [0.0005,0.999]})\n ),\n\n // vl.markTick({color: 'red', thickness: 2.5, width: 30})\n // .encode(\n // vl.x().fieldT('date'),\n // vl.y().median('salary_extract')\n // ),\n\n // vl.markText({dx: 27, dy: 15})\n // .encode(\n // vl.x().fieldT('date'),\n // vl.text().median('salary_extract')\n // ),\n\n // vl.markLine({color: 'red', strokeDash: [15,5], point: {color: 'red', size: 50}, opacity: 0.3})\n // .encode(\n // vl.x().fieldT('date'),\n // vl.y().median('salary_extract')\n // ),\n\n \n )\n .data(clean_week_split)\n .config(clean_config)\n .width(width - 200)\n .render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":729,"value":"vl.markRect({color: appc2_color_scheme[0], width: {band: 0.75}})\n .data(clean_week_split)\n .encode(\n vl.x().fieldT('date').timeUnit('utcmonthdate'),\n vl.y().fieldQ('salary_extract').bin(true),\n vl.opacity().count()\n )\n .config(clean_config)\n .width(600)\n .render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1065,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":937,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1185,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W36","stdlib":"1"}} 30:"$2f:body"