2f: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()30: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() }31: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()32: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()33: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()34:[] 2d:{"title":"Competitor Salary Overview","cells":[{"id":0,"value":"title6 = md `# Competitor Salary Overview`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1213,"value":"break4 = html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1216,"value":"title1 = md `### Competitive Intelligence - Master File`","pinned":false,"hidden":false,"mode":"ojs"},{"id":781,"value":"viewof file = Inputs.file({label: \"Load data\", required: true})","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"id":785,"value":"break1 = html `

`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":2057,"value":"md `
\n## Filter to a specific Geographic Area`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2063,"value":"html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"id":1157,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":1312,"value":"title5 = md `**_Control Panel for Salary Charts_**`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":1196,"value":"break3 = html `

`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"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"},{"id":688,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":1496,"value":"title7 = md `
\n## My_Company vs Market Median Salary over time`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2181,"value":"aq.from(selected_companies).view()","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":88,"value":"break5 = html `
\n
\n
\n

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":20,"value":"md `## Appendix\n\n_Implementation & data stuff_`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2121,"value":"selected_companies_array = selected_companies.map(d => d.Company)","pinned":false,"hidden":false,"mode":"ojs"},{"id":198,"value":"### *Data*","pinned":false,"hidden":false,"mode":"md"},{"id":538,"value":"Inputs.table(clean_week_split)","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"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"},{"id":807,"value":"data_nodeFL = data.filter(d => d.Node == node_selector)","pinned":true,"hidden":false,"mode":"ojs"},{"id":394,"value":"data = file.csv()","pinned":true,"hidden":false,"mode":"ojs"},{"id":916,"value":"### By 2 week period","pinned":false,"hidden":false,"mode":"md"},{"id":990,"value":"*Recent 2 Weeks*","pinned":false,"hidden":false,"mode":"md"},{"id":1756,"value":"#### Node level","pinned":false,"hidden":false,"mode":"md"},{"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"},{"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"},{"id":1002,"value":"cw_list = aq.from(rp_top)\n .select('Company')\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1010,"value":"cw_list2 = companies(cw_list)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1013,"value":"cw_list3 = cw_list2.Company","pinned":true,"hidden":false,"mode":"ojs"},{"id":1760,"value":"#### Multi site level","pinned":false,"hidden":false,"mode":"md"},{"id":994,"value":"*Previous 2 Weeks*","pinned":false,"hidden":false,"mode":"md"},{"id":1776,"value":"#### Node level","pinned":false,"hidden":false,"mode":"md"},{"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"},{"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"},{"id":1019,"value":"pw_list = aq.from(pp_top)\n .select('Company')\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1022,"value":"pw_list2 = companies(pw_list)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1024,"value":"pw_list3 = pw_list2.Company","pinned":true,"hidden":false,"mode":"ojs"},{"id":1742,"value":"#### Multi site level","pinned":false,"hidden":false,"mode":"md"},{"id":402,"value":"#### Date","pinned":false,"hidden":false,"mode":"md"},{"id":573,"value":"formatter = d3.timeFormat('%d %B %Y')","pinned":true,"hidden":false,"mode":"ojs"},{"id":1282,"value":"formatter2 = d3.timeFormat('%A %b %d, %Y')","pinned":true,"hidden":false,"mode":"ojs"},{"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"},{"id":412,"value":"date_range = d3.extent(data_date_range, d => d.date)","pinned":true,"hidden":false,"mode":"ojs"},{"id":415,"value":"two_weeks_back = d3.timeDay.offset(date_range[1], -14)","pinned":true,"hidden":false,"mode":"ojs"},{"id":193,"value":"### *Libraries*","pinned":false,"hidden":false,"mode":"md"},{"id":4,"value":"import {vl} from '@vega/vega-lite-api-v5'","pinned":false,"hidden":false,"mode":"ojs"},{"id":36,"value":"import {uniqueValid} from '@uwdata/data-utilities'","pinned":false,"hidden":false,"mode":"ojs"},{"id":59,"value":"import { aq, op } from '@uwdata/arquero'","pinned":false,"hidden":false,"mode":"ojs"},{"id":139,"value":"// object containing all of the FIPS us state codes\n\nimport {statemap} from \"@d3/choropleth\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":137,"value":"// object containing all of the FiPS us county codes\n\nimport {counties} from \"@d3/choropleth\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":151,"value":"import {countyShapes} from \"@enjalot/us-county-datasets\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":159,"value":"//example to use the file above\ncountyShapes.features[0].properties.name","pinned":true,"hidden":false,"mode":"ojs"},{"id":208,"value":"### *Chart configuration*","pinned":false,"hidden":false,"mode":"md"},{"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"},{"id":1088,"value":"myCompany_color_palette = ['#3138BB', '#FF7D6F', '#AF9BFC', '#C7FFE2', '#127FFC', '#FF9B77', '#FAFAFA']","pinned":true,"hidden":false,"mode":"ojs"},{"id":457,"value":"appc2_color_scheme = ['#127ffc', '#d3d3d3']","pinned":true,"hidden":false,"mode":"ojs"},{"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"},{"id":811,"value":"### *Visualization Iterations*","pinned":false,"hidden":false,"mode":"md"},{"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"},{"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"},{"id":1065,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":937,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":1185,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}