2f:T720,wh_heatmap = vl.hconcat( vl.markRect({tooltip: true, width: { band: 0.97 }, height: { band: 0.95 }}) .data(clean.filter(d => final_list.includes(d.Company))) .transform( vl.filter('datum.keyword == "warehouse"'), ) .encode( vl.x().fieldT("date").timeUnit("monthdate").axis({ grid: false, orient: "top", tickOpacity: 0.2, labelOpacity: 0.3 }) .title(null), vl.y().fieldN("Company") .sort(vl.sum("market_share").order("descending")) .title(null), vl.color().fieldQ("count").scale({range: ['#fafafa', _color]}) .legend({ labelFontWeight: 200, tickCount: 5, title: "Number of posts on first page per day", titleLimit: 1000, titleFontWeight: 200, orient: "bottom", direction: 'horizontal', gradientThickness: 6, offset: -20 }) ) .width(ctrl_panel.hm_width) .height(ctrl_panel.hm_height), // bar chart vl.data(wh_clean) .encode( vl.y().fieldN('Company').sort(vl.max('t_mk').order('descending')).title(null) ) .layer( vl.markBar({color: _color, height: {band: 0.9}, opacity: 1}) .encode( vl.x().fieldQ('t_mk').axis({format: '%', titlePadding: 40, titleFontWeight: 200, titleFontSize: 13, labelOpacity: 0.3, tickOpacity: 0.3, labelFontWeight: 200}) .title("Total Market Share Percent (%)") ), vl.markText({ dx: 16, size: 8.5, opacity: 0.6}) .encode( vl.x().fieldQ('t_mk').axis({format: '%'}), vl.text({format: '.1%'}).fieldQ("t_mk") ) ) .width(250) .height(ctrl_panel.hm_height) ) .spacing(ctrl_panel.inner_space) .padding({left: 35, top: 40, bottom: 40, right: 20}) .config(clean_config) .render()30:T8be,uh_heatmap = vl .hconcat( vl .markRect({ tooltip: true, width: { band: 0.97 }, height: { band: 0.95 } }) .data(clean.filter((d) => uh_final_list.includes(d.Company))) .transform(vl.filter('datum.keyword == "urgent+hire"')) .encode( vl .x().fieldT("date").timeUnit("monthdate") .axis({ grid: false, orient: "top", tickOpacity: 0.2, labelOpacity: 0.3 }) .title(null), vl.y().fieldN("Company").sort(vl.sum("market_share").order("descending")).title(null), vl.color().fieldQ("count") .scale({ range: ["#fafafa", _color] }) .legend({ labelFontWeight: 200, tickCount: 5, title: "Number of posts on first page per day", titleLimit: 1000, titleFontWeight: 200, orient: "bottom", direction: "horizontal", gradientThickness: 6, offset: -20 }) ) .width(ctrl_panel.hm_width) .height(ctrl_panel.hm_height), vl .data(uh_clean) .encode( vl .y() .fieldN("Company") .sort(vl.max("t_mk").order("descending")) .title(null) ) .layer( vl .markBar({ color: _color, height: { band: 0.9 }, opacity: 1 }) .encode( vl .x() .fieldQ("t_mk") .axis({ format: "%", titlePadding: 40, titleFontWeight: 200, titleFontSize: 13, labelOpacity: 0.3, tickOpacity: 0.3, labelFontWeight: 200 }) .title("Total Market Share Percent (%)") ), vl .markText({ dx: 16, size: 8.5, opacity: 0.6 }) .encode( vl.x().fieldQ("t_mk").axis({ format: "%" }), vl.text({ format: ".1%" }).fieldQ("t_mk") ) ) .width(250) .height(ctrl_panel.hm_height) ) .spacing(ctrl_panel.inner_space) .padding({ left: 35, top: 40, bottom: 40, right: 20 }) .config(clean_config) .render()31:[] 2d:{"title":"Competitor Market Share","cells":[{"id":0,"value":"title2 = md `# Competitor Market Share`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1924,"value":"break2 = html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1722,"value":"title1 = md `### Competitor Intel Master File`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1284,"value":"viewof file = Inputs.file({label: \"Load Data\", required: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1719,"value":"req_date_range_text = md `Date range: from **${formatter(data_date_range[0])}** to **${formatter(data_date_range[1])}**`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1288,"value":"break3 = html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1108,"value":"viewof node_selector = Inputs.select(loaded_file.map(d => d.Node), {label: \"Select a Node\", unique: true, sort: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":734,"value":"break4 = html `

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":725,"value":"title3 = md `### *Market Share: warehouse*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1184,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":1881,"value":"break1 = html `

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1187,"value":"title4 = md `### *Market Share: urgent hire*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1826,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":2300,"value":"break11 = html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1871,"value":"title5 = md `**_Control Panel for Market Share Charts_**`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1904,"value":"viewof _color = Object.assign(Inputs.radio(appcast_color_palette, {\n value: appcast_color_palette[1],\n label: html`Heatmap Color`,\n format: (x) => html`${x}`\n}), {style: '--label-width: 195px'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1947,"value":"viewof ctrl_panel = Inputs.form({\n inner_space: Object.assign(Inputs.range([0, 200], {label: \"Space between charts\", step: 5}), {style: '--label-width: 200px'}),\n hm_width: Object.assign(Inputs.range([0, 600], {label: \"Heatmap Width\", step: 5, value: 315}), {style: '--label-width: 200px'}),\n hm_height: Object.assign(Inputs.range([0,600], {label: \"Heatmap Height\", step: 5, value: 220}), {style: '--label-width: 200px'})\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":738,"value":"break5 = md `

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":689,"value":"title6 = md `## Competitor Triggers or Title Keywords`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2087,"value":"break9 = html`
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2079,"value":"Object.assign(Inputs.bind(Inputs.select(loaded_file.map(d => d.Node), {label: \"Select a Node\", unique: true, sort: true}), viewof node_selector), {style: '--label-width: 195px'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2330,"value":"viewof keyword = Object.assign(Inputs.select(['bonus', 'benefits', 'forklift'], {label: \"Select a trigger or keyword\", value: 'bonus'}),{style: '--label-width: 195px'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":676,"value":"bonus_heatmap = vl.markRect({tooltip: true, width: {band: 0.97}, height: {band: 0.95}})\n .data(bonus) //.filter(d => d.Company != 'Amazon.com'))\n .title({text: 'Keyword: ' + keyword, anchor: 'start', fontSize: 20, offset: 50})\n .encode(\n vl.x().fieldT('Date').timeUnit('utcmonthdate').axis({grid: false, orient: 'top', tickOpacity: 0.3, labelOpacity: 0.3}).title(null),\n vl.y().fieldN('Company').sort(vl.sum('count').order('descending')).title(null),\n vl.color().fieldQ('count')\n .legend({labelFontWeight: 200, tickCount: 4, title: \"Number of posts on first page per day\", titleLimit: 1000, titleFontWeight: 200, orient: 'bottom', offset: 45, gradientThickness: 7})\n .scale({range: ['#f2f2f2','#127ffc'], reverse: false})\n )\n .config(clean_config)\n .padding({left: 70, top: 25})\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1275,"value":"break6 = html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":710,"value":"viewof bonus_table = html`

${Inputs.table(\n aq\n .from(bonus)\n .dedupe(\"Company\", \"Title\")\n .select(aq.not(\"Date\", \"count\"))\n //.filter(d => d.Company != 'Amazon.com')\n .objects(),\n { layout: \"auto\",\n width: 900\n }\n)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":717,"value":"break7 = html `

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1219,"value":"break8 = html `

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":760,"value":"
","pinned":false,"hidden":false,"mode":"html"},{"id":1198,"value":"
","pinned":false,"hidden":false,"mode":"html"},{"id":88,"value":"
\n
\n
\n
\n
\n

","pinned":false,"hidden":false,"mode":"html"},{"id":20,"value":"md `## Appendix\n\n_Implementation & data stuff_`","pinned":false,"hidden":false,"mode":"ojs"},{"id":198,"value":"### *Data*","pinned":false,"hidden":false,"mode":"md"},{"id":1516,"value":"loaded_file = file.csv()","pinned":true,"hidden":false,"mode":"ojs"},{"id":2108,"value":"### *Node Filtering*","pinned":false,"hidden":false,"mode":"md"},{"id":1105,"value":"clean_NodeFL = loaded_file.filter(d => d.Node == node_selector)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1117,"value":" clean = aq.from(clean_NodeFL)\n .derive({date: d => op.parse_date(d.Date)}, {after: 'Date'})\n .groupby('date', 'Company','keyword')\n .count()\n .groupby('keyword')\n .derive({market_share: d => d.count/op.sum(d.count)}) // calculate market share\n .orderby(aq.desc('market_share'))\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1527,"value":"### Split for each keyword","pinned":false,"hidden":false,"mode":"md"},{"id":1557,"value":"*warehouse*","pinned":false,"hidden":false,"mode":"md"},{"id":1546,"value":"Inputs.table(wh_clean)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1475,"value":"wh_clean = aq.from(clean)\n .filter(d => d.keyword == 'warehouse')\n .groupby('Company')\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() <= 10)\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1679,"value":"final_list = wh_clean.map(d => d.Company)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1563,"value":"*urgent hire*","pinned":false,"hidden":false,"mode":"md"},{"id":1567,"value":"Inputs.table(uh_clean)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1696,"value":"uh_final_list = uh_clean.map(d => d.Company)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1494,"value":"uh_clean = aq.from(clean)\n .filter(d => d.keyword == 'urgent+hire')\n .groupby('Company') //, 'market_share')\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() <= 10)\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1303,"value":"### *Triggers*","pinned":false,"hidden":false,"mode":"md"},{"id":1506,"value":"triggers_nodeFL = loaded_file.filter(d => d.Node == node_selector)","pinned":true,"hidden":false,"mode":"ojs"},{"id":680,"value":"Inputs.table(bonus, {layout: 'auto'})","pinned":true,"hidden":false,"mode":"ojs"},{"id":663,"value":"bonus = aq.from(triggers_nodeFL)\n .filter(aq.escape(d => op.includes(op.lower(d.Title), keyword)))\n .groupby('Date', 'Company', 'Title')\n .count()\n .orderby('Date')\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":704,"value":"Inputs.table(benefits)","pinned":false,"hidden":false,"mode":"ojs"},{"id":702,"value":"benefits = aq.from(triggers_nodeFL)\n .filter(d => op.includes(op.lower(d.Title), 'benefits'))\n .groupby('Date', 'Company', 'Title')\n .count()\n .orderby('Date')\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":187,"value":"### *Secondary data sources*","pinned":false,"hidden":false,"mode":"md"},{"id":69,"value":"// all vega data-sets\n\n// to 'extract' a dataset as an array (only for .csv and .json)\n// use this format: football = v_data['football.json']()\n// for some .csv, it's better to use the url format: zipcodes = v_data['zipcodes.csv'].url\n// this is due to the fact that parsing it as an array of objects results in zipcodes of the form \"00313\" turning into \"313\"\n\nv_data = require('vega-datasets@2')","pinned":false,"hidden":false,"mode":"ojs"},{"id":98,"value":"zips = v_data['zipcodes.csv'].url","pinned":false,"hidden":false,"mode":"ojs"},{"id":1705,"value":"### *Dates*","pinned":false,"hidden":false,"mode":"md"},{"id":1710,"value":"data_date_range = d3.extent(clean, d => d.date)","pinned":true,"hidden":false,"mode":"ojs"},{"id":193,"value":"### *Libraries*","pinned":false,"hidden":false,"mode":"md"},{"id":1703,"value":"formatter = d3.utcFormat ('%A %b %d, %Y') // Weekday Month Day, Year","pinned":true,"hidden":false,"mode":"ojs"},{"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":997,"value":"appc4_color_scheme = ['#002d19', '#194c36', '#3a6d55', '#5c8f76', '#7eb399', '#a2d9bd', '#c7ffe2']","pinned":false,"hidden":false,"mode":"ojs"},{"id":990,"value":"appc3_color_scheme = ['#400000', '#671704', '#893619', '#ac5435', '#d07351', '#f5926f', '#ffc09a']","pinned":false,"hidden":false,"mode":"ojs"},{"id":979,"value":"appc2_color_scheme = ['#127ffc', '#6c9ff6', '#9ac1f0', '#c3e3e8', '#ffffe0']","pinned":false,"hidden":false,"mode":"ojs"},{"id":968,"value":"appc1_color_scheme = ['#3138bb', '#6456c3', '#8876ca', '#a896d0', '#c6b8d6', '#e3dbdb', '#ffffe0']","pinned":false,"hidden":false,"mode":"ojs"},{"id":1740,"value":"appcast_color_palette = ['#3138BB', '#FF7D6F', '#AF9BFC', '#C7FFE2', '#127FFC', '#FF9B77']","pinned":true,"hidden":false,"mode":"ojs"},{"id":202,"value":"clean_config = ({\n view: { stroke: null },\n axis: {\n //gridOpacity: 0.5,\n gridColor: 'white',\n gridWidth: 1,\n //grid: true,\n tickBand: 'extent',\n labelFontWeight: 75,\n domain: false,\n offset: 5,\n titleFontWeight: 350,\n titleFontSize: 10,\n //zindex: 5\n },\n axisX: {\n tickCount: 5,\n //titlePadding: 10,\n labelPadding: 4,\n //labelFontSize: 7\n },\n axisY: {\n ticks: false,\n labelLimit: 300,\n labelFontSize: 9,\n titlePadding: 30,\n labelPadding: 12.5\n },\n title: {\n fontWeight: 300,\n fontSize: 13,\n offset: 25\n }\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1728,"value":"viewof radios = Inputs.select([\"bluegreen\", \"bluepurple\", \"lightgreyred\", \"lightgreyteal\", \"lightorange\", \"lighttealblue\", \"yellowgreenblue\"], {label: \"Select one\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1743,"value":"viewof select = Inputs.select(appcast_color_palette, {label: \"Select one\"})","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}