2f:T72b,country_heatmap = vl.hconcat( // heatmap vl.markRect({tooltip: true, width: { band: 0.97 }, height: { band: 0.95 }}) .data(clean_country.filter(d => country_final_list.includes(d.company))) .encode( vl.x().fieldT("date").timeUnit("yearmonthdate") .axis({ grid: false, orient: "top", tickOpacity: 0.2, labelOpacity: 0.3, tickCount: 'week' }) .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: "Posting intensity by day", titleLimit: 1000, titleFontWeight: 200, orient: "bottom", direction: 'horizontal', gradientThickness: 6, offset: -20 }) ) .width(ctrl_panel.hm_width), // bar chart vl.data(clean_country_market_pct) .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(ctrl_panel.bar_chart_width) ) .spacing(ctrl_panel.inner_space) .padding({left: 35, top: 40, bottom: 40, right: 20}) .config(clean_config) .render()30:T72a,all_heatmap = vl.hconcat( // heatmap vl.markRect({tooltip: true, width: { band: 0.97 }, height: { band: 0.95 }}) .data(clean2.filter(d => all_final_list.includes(d.company))) .encode( vl.x().fieldT("date").timeUnit("yearmonthdate") .axis({ grid: false, orient: "top", tickOpacity: 0.2, labelOpacity: 0.3, tickCount: 'week' }) .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: "Posting intensity by day", titleLimit: 1000, titleFontWeight: 200, orient: "bottom", direction: 'horizontal', gradientThickness: 6, offset: -20 }) ) .width(ctrl_panel.hm_width), // bar chart vl.data(clean_market_pct) //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(ctrl_panel.bar_chart_width) ) .spacing(ctrl_panel.inner_space) .padding({left: 35, top: 40, bottom: 40, right: 20}) .config(clean_config) .render()31:Ta00,// all_Msite_heatmap = vl // .hconcat( // vl // .markRect({ // tooltip: true, // width: { band: 0.97 }, // height: { band: 0.95 } // }) // .data(clean_by_multi_site2.filter((d) => multi_site_list_allK.includes(d.company))) // .encode( // vl // .x().fieldT("date").timeUnit("yearmonthdate") // .axis({ // grid: false, // orient: "top", // tickOpacity: 0.2, // labelOpacity: 0.3, // tickCount: 'week' // }) // .title(null), // vl.y().fieldN("company").sort(vl.sum("market_share").order("descending")).title(null), // //vl.color().fieldQ("count") // I changed this on Aug 22, 2022 -- I was not summing the counts // vl.color().sum('count') // .scale({ range: ["#f2f2f2", _color] }) // .legend({ // labelFontWeight: 200, // //tickCount: 5, // title: "Posting intensity by day", // titleLimit: 1000, // titleFontWeight: 200, // orient: "bottom", // direction: "horizontal", // gradientThickness: 6, // offset: -20, // //format: '.0f' // }) // ) // .width(ctrl_panel.hm_width), // vl // .data(clean_by_multi_site_mk_pct) // .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(ctrl_panel.bar_chart_width) // ) // .spacing(ctrl_panel.inner_space) // .padding({ left: 35, top: 40, bottom: 40, right: 20 }) // .config(clean_config) // .render()32:T97f,// single_site_heatmap = vl // .hconcat( // // heatmap // vl // .markRect({ // tooltip: true, // width: { band: 0.97 }, // height: { band: 0.95 } // }) // .data(clean_by_site2.filter(d => single_site_list.includes(d.company) ) ) // .encode( // vl // .x().fieldT("date").timeUnit("yearmonthdate") // .axis({ // grid: false, // orient: "top", // tickOpacity: 0.2, // labelOpacity: 0.3, // tickCount: 'week' // }) // .title(null), // vl.y().fieldN("company").sort(vl.sum("market_share").order("descending")).title(null), // vl.color().fieldQ("count") // .scale({ range: ["#f2f2f2", _color] }) // .legend({ // labelFontWeight: 200, // tickCount: 5, // title: "Posting intensity by day", // titleLimit: 1000, // titleFontWeight: 200, // orient: "bottom", // direction: "horizontal", // gradientThickness: 6, // offset: -20 // }) // ) // .width(ctrl_panel.hm_width), // vl // .data(clean_by_site_mk_pct) // .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(ctrl_panel.bar_chart_width) // ) // .spacing(ctrl_panel.inner_space) // .padding({ left: 35, top: 40, bottom: 40, right: 20 }) // .config(clean_config) // .render()33:T74f,wh_heatmap = vl.hconcat( // heatmap 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, tickCount: 'week' }) .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: "Posting intensity by day", titleLimit: 1000, titleFontWeight: 200, orient: "bottom", direction: 'horizontal', gradientThickness: 6, offset: -20 }) ) .width(ctrl_panel.hm_width), // 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(ctrl_panel.bar_chart_width) ) .spacing(ctrl_panel.inner_space) .padding({left: 35, top: 40, bottom: 40, right: 20}) .config(clean_config) .render()34:T89f,pp_heatmap = vl .hconcat( vl .markRect({ tooltip: true, width: { band: 0.97 }, height: { band: 0.95 } }) .data(clean.filter((d) => pp_final_list.includes(d.company))) .transform(vl.filter('datum.keyword == "picker+packer"')) .encode( vl .x().fieldT("date").timeUnit("monthdate") .axis({ grid: false, orient: "top", tickOpacity: 0.2, labelOpacity: 0.3, tickCount: 'week' }) .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: "Posting intensity by day", titleLimit: 1000, titleFontWeight: 200, orient: "bottom", direction: "horizontal", gradientThickness: 6, offset: -20 }) ) .width(ctrl_panel.hm_width), vl .data(pp_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(ctrl_panel.bar_chart_width) ) .spacing(ctrl_panel.inner_space) .padding({ left: 35, top: 40, bottom: 40, right: 20 }) .config(clean_config) .render()35:T89b,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 == "lager"')) .encode( vl .x().fieldT("date").timeUnit("yearmonthdate") .axis({ grid: false, orient: "top", tickOpacity: 0.2, labelOpacity: 0.3, tickCount: 'week' }) .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: "Posting intensity by day", titleLimit: 1000, titleFontWeight: 200, orient: "bottom", direction: "horizontal", gradientThickness: 6, offset: -20 }) ) .width(ctrl_panel.hm_width), 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(ctrl_panel.bar_chart_width) ) .spacing(ctrl_panel.inner_space) .padding({ left: 35, top: 40, bottom: 40, right: 20 }) .config(clean_config) .render()36:T8a2,dis_heatmap = vl .hconcat( vl .markRect({ tooltip: true, width: { band: 0.97 }, height: { band: 0.95 } }) .data(clean.filter((d) => dis_final_list.includes(d.company))) .transform(vl.filter('datum.keyword == "disponent"')) .encode( vl .x().fieldT("date").timeUnit("yearmonthdate") .axis({ grid: false, orient: "top", tickOpacity: 0.2, labelOpacity: 0.3, tickCount: 'week' }) .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: "Posting intensity by day", titleLimit: 1000, titleFontWeight: 200, orient: "bottom", direction: "horizontal", gradientThickness: 6, offset: -20 }) ) .width(ctrl_panel.hm_width), vl .data(dis_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(ctrl_panel.bar_chart_width) ) .spacing(ctrl_panel.inner_space) .padding({ left: 35, top: 40, bottom: 40, right: 20 }) .config(clean_config) .render()37:T99a,// wh_site_heatmap = vl // .hconcat( // vl // .markRect({ // tooltip: true, // width: { band: 0.97 }, // height: { band: 0.95 } // }) // .data(clean_by_site.filter((d) => final_site_list.includes(d.company))) // .transform(vl.filter('datum.keyword == "warehouse"')) // .encode( // vl // .x().fieldT("date").timeUnit("yearmonthdate") // .axis({ // grid: false, // orient: "top", // tickOpacity: 0.2, // labelOpacity: 0.3, // tickCount: 'week' // }) // .title(null), // vl.y().fieldN("company").sort(vl.sum("market_share").order("descending")).title(null), // vl.color().fieldQ("count") // .scale({ range: ["#f2f2f2", _color] }) // .legend({ // labelFontWeight: 200, // tickCount: 5, // title: "Posting intensity by day", // titleLimit: 1000, // titleFontWeight: 200, // orient: "bottom", // direction: "horizontal", // gradientThickness: 6, // offset: -20 // }) // ) // .width(ctrl_panel.hm_width), // vl // .data(wh_clean_site) // .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(ctrl_panel.bar_chart_width) // ) // .spacing(ctrl_panel.inner_space) // .padding({ left: 35, top: 40, bottom: 40, right: 20 }) // .config(clean_config) // .render()38:T999,// uh_site_heatmap = vl // .hconcat( // vl // .markRect({ // tooltip: true, // width: { band: 0.97 }, // height: { band: 0.95 } // }) // .data(clean_by_site.filter((d) => uh_final_site_list.includes(d.company))) // .transform(vl.filter('datum.keyword == "lager"')) // .encode( // vl // .x().fieldT("date").timeUnit("yearmonthdate") // .axis({ // grid: false, // orient: "top", // tickOpacity: 0.2, // labelOpacity: 0.3, // tickCount: 'week' // }) // .title(null), // vl.y().fieldN("company").sort(vl.sum("market_share").order("descending")).title(null), // vl.color().fieldQ("count") // .scale({ range: ["#f2f2f2", _color] }) // .legend({ // labelFontWeight: 200, // tickCount: 5, // title: "Posting intensity by day", // titleLimit: 1000, // titleFontWeight: 200, // orient: "bottom", // direction: "horizontal", // gradientThickness: 6, // offset: -20 // }) // ) // .width(ctrl_panel.hm_width), // vl // .data(uh_clean_site) // .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(ctrl_panel.bar_chart_width) // ) // .spacing(ctrl_panel.inner_space) // .padding({ left: 35, top: 40, bottom: 40, right: 20 }) // .config(clean_config) // .render()39:Ta30,// wh_Msite_heatmap = vl // .hconcat( // vl // .markRect({ // tooltip: true, // width: { band: 0.97 }, // height: { band: 0.95 } // }) // .data(clean_by_multi_site.filter((d) => wh_final_Msite_list.includes(d.company))) // .transform(vl.filter('datum.keyword == "warehouse"')) // .encode( // vl // .x().fieldT("date").timeUnit("yearmonthdate") // .axis({ // grid: false, // orient: "top", // tickOpacity: 0.2, // labelOpacity: 0.3, // tickCount: 'week' // }) // .title(null), // vl.y().fieldN("company").sort(vl.sum("market_share").order("descending")).title(null), // //vl.color().fieldQ("count") // I changed this on Aug 22, 2022 -- I was not summing the counts // vl.color().sum('count') // .scale({ range: ["#f2f2f2", _color] }) // .legend({ // labelFontWeight: 200, // //tickCount: 5, // title: "Posting intensity by day", // titleLimit: 1000, // titleFontWeight: 200, // orient: "bottom", // direction: "horizontal", // gradientThickness: 6, // offset: -20, // //format: '.0f' // }) // ) // .width(ctrl_panel.hm_width), // vl // .data(wh_clean_Msite) // .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(ctrl_panel.bar_chart_width) // ) // .spacing(ctrl_panel.inner_space) // .padding({ left: 35, top: 40, bottom: 40, right: 20 }) // .config(clean_config) // .render()3a:Ta0c,// uh_Msite_heatmap = vl // .hconcat( // vl // .markRect({ // tooltip: true, // width: { band: 0.97 }, // height: { band: 0.95 } // }) // .data(clean_by_multi_site.filter((d) => uh_final_Msite_list.includes(d.company))) // .transform(vl.filter('datum.keyword == "lager"')) // .encode( // vl // .x().fieldT("date").timeUnit("yearmonthdate") // .axis({ // grid: false, // orient: "top", // tickOpacity: 0.2, // labelOpacity: 0.3, // tickCount: 'week' // }) // .title(null), // vl.y().fieldN("company").sort(vl.sum("market_share").order("descending")).title(null), // //vl.color().fieldQ("count") // I changed this on Aug 22, 2022 -- I was not summing the counts // vl.color().sum('count') // .scale({ range: ["#f2f2f2", _color] }) // .legend({ // labelFontWeight: 200, // //tickCount: 5, // title: "Posting intensity by day", // titleLimit: 1000, // titleFontWeight: 200, // orient: "bottom", // direction: "horizontal", // gradientThickness: 6, // offset: -20 // }) // ) // .width(ctrl_panel.hm_width), // vl // .data(uh_clean_Msite) // .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(ctrl_panel.bar_chart_width) // ) // .spacing(ctrl_panel.inner_space) // .padding({ left: 35, top: 40, bottom: 40, right: 20 }) // .config(clean_config) // .render()3b:[{"id":"7b59959e8d0b13881ed5b56e356e22fd1b5184ce62ae45ac2a928197cdb9cba011101f6b3572adc34717f9e4914887a66997f5f69c4bcdcf58158f0db5bb8a0e","href":"https://static.observableusercontent.com/files/7b59959e8d0b13881ed5b56e356e22fd1b5184ce62ae45ac2a928197cdb9cba011101f6b3572adc34717f9e4914887a66997f5f69c4bcdcf58158f0db5bb8a0e","name":"Competitive Analysis - Workforce Staffing_Data Download for Aldo Template_Table (9).csv","type":"text/csv","lastModified":1657049778730.504,"size":338842}] 2d:{"title":"Europe Competitor Market Share","cells":[{"id":0,"value":"title2 = md `# Europe 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 of data for this country: 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":3222,"value":"md `## Country`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2377,"value":"viewof country_selector = Inputs.select(loaded_file.map(d => d.country), {label: \"Select a Country\", unique: true, sort: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":3205,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":734,"value":"break4 = html `

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":3225,"value":"md `## Region`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1108,"value":"viewof node_selector = Inputs.select(data_countryFL.map(d => d.search_market), {label: \"Select a Region\", unique: true, sort: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2848,"value":"title17 = md `### *Market Share (all keywords)*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2865,"value":"Inputs.table(aq.from(clean)\n .select('keyword')\n .dedupe()\n .rename({\n keyword: 'Keywords Included'\n })\n .objects(), {width: 300})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2830,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":2987,"value":"vl.data(clean_market_pct)\n .encode(\n vl.y().fieldN('company').sort(vl.max('t_mk').order('descending')).title(null)\n )\n .layer(\n vl.markBar({color: _color, height: {band: 0.9}, opacity: 1})\n .encode(\n vl.x().fieldQ('t_ct')\n .axis({\n titlePadding: 20, titleFontWeight: 200, titleFontSize: 13, \n labelOpacity: 0.3, labelFontWeight: 200,\n tickOpacity: 0.3\n })\n .title(\"Number of posts\")\n ),\n vl.markText({ dx: 10, size: 8.5, opacity: 0.6})\n .encode(\n vl.x().fieldQ('t_ct'),\n vl.text().fieldQ(\"t_ct\")\n )\n )\n .padding({top: 25, bottom: 25, left: 35})\n .width(ctrl_panel.bar_chart_width)\n .config(clean_config)\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1881,"value":"break1 = 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: 365}), {style: '--label-width: 200px'}),\n bar_chart_width: Object.assign(Inputs.range([50,250], {label: \"Bar Chart Width\", step: 5, value: 185}), {style: '--label-width: 200px'})\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":738,"value":"break5 = md `

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2087,"value":"break9 = html`
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1275,"value":"break6 = html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":717,"value":"break7 = html `

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1280,"value":"html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2948,"value":"html `

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2858,"value":"md `# Legacy charts`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2209,"value":"title10 = md `## Multiple Sites`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2300,"value":"break11 = html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2213,"value":"// viewof mult_site_selector = Object.assign(\n// Inputs.checkbox(\n// clean_NodeFL.map((d) => d.search_submarket),\n// {\n// label: \"Select a Site or Sites\",\n// unique: true,\n// sort: true,\n// value: multi_site_unique_list\n// }\n// ),\n// { style: \"--label-width: 175px\" }\n// )","pinned":false,"hidden":false,"mode":"ojs"},{"id":2297,"value":"break10 = html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2924,"value":"md `### *Market Share (all keywords)*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2927,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":3006,"value":"// vl.data(clean_by_multi_site_mk_pct)\n// .encode(\n// vl.y().fieldN('company').sort(vl.max('t_mk').order('descending')).title(null)\n// )\n// .layer(\n// vl.markBar({color: _color, height: {band: 0.9}, opacity: 1})\n// .encode(\n// vl.x().fieldQ('t_ct')\n// .axis({\n// titlePadding: 20, titleFontWeight: 200, titleFontSize: 13, \n// labelOpacity: 0.3, labelFontWeight: 200,\n// tickOpacity: 0.3\n// })\n// .title(\"Number of posts\")\n// ),\n// vl.markText({ dx: 10, size: 8.5, opacity: 0.6})\n// .encode(\n// vl.x().fieldQ('t_ct'),\n// vl.text().fieldQ(\"t_ct\")\n// )\n// )\n// .padding({top: 25, bottom: 25, left: 35})\n// .width(ctrl_panel.bar_chart_width)\n// .config(clean_config)\n// .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":2125,"value":"title7 = md `## By Single Site`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2525,"value":"// Inputs.bind(Inputs.select(loaded_file.map(d => d.country), {label: \"Select a Country\", unique: true, sort: true}), viewof country_selector)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2176,"value":"// Inputs.bind(Inputs.select(data_countryFL.map(d => d.search_market), {label: \"Select a Node\", unique: true, sort: true}), viewof node_selector)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2098,"value":"// viewof site_selector = Inputs.select(clean_NodeFL.map(d => d.search_submarket), {label: \"Select a Site\", unique: true, sort: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2911,"value":"md `### *Market Share (all keywords)*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2884,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":3009,"value":"// vl.data(clean_by_site_mk_pct)\n// .encode(\n// vl.y().fieldN('company').sort(vl.max('t_mk').order('descending')).title(null)\n// )\n// .layer(\n// vl.markBar({color: _color, height: {band: 0.9}, opacity: 1})\n// .encode(\n// vl.x().fieldQ('t_ct')\n// .axis({\n// titlePadding: 20, titleFontWeight: 200, titleFontSize: 13, \n// labelOpacity: 0.3, labelFontWeight: 200,\n// tickOpacity: 0.3\n// })\n// .title(\"Number of posts\")\n// ),\n// vl.markText({ dx: 10, size: 8.5, opacity: 0.6})\n// .encode(\n// vl.x().fieldQ('t_ct'),\n// vl.text().fieldQ(\"t_ct\")\n// )\n// )\n// .padding({top: 25, bottom: 25, left: 35})\n// .width(ctrl_panel.bar_chart_width)\n// .config(clean_config)\n// .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":2568,"value":"title15 = md `## Total Unique Competitors\n\n*by Node*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2611,"value":"Inputs.bind(Inputs.select(loaded_file.map(d => d.country), {label: \"Select a Country\", unique: true, sort: true}), viewof country_selector)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2614,"value":"Inputs.bind(Inputs.select(data_countryFL.map(d => d.search_market), {label: \"Select a Node\", unique: true, sort: true}), viewof node_selector)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2617,"value":"html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2951,"value":"Plot.plot({\n insetTop: 25,\n width,\n grid: true,\n y: {\n label: 'Total distinct competitors ↑',\n //labelOffset: 20\n },\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(unique_competitors, {x: \"date\", y: \"distinct\", marker: true, stroke: appc2_color_scheme[0]})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2896,"value":"md `## Node level`","pinned":false,"hidden":false,"mode":"ojs"},{"id":725,"value":"title3 = md `### *Market Share: warehouse*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1184,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":2380,"value":"md `### *Market Share: picker packer*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2383,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":1187,"value":"title4 = md `### *Market Share: lager*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1826,"value":"$35","pinned":false,"hidden":false,"mode":"ojs"},{"id":2372,"value":"md `### *Market Share: disponent*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2361,"value":"$36","pinned":false,"hidden":false,"mode":"ojs"},{"id":2899,"value":"md `## Site level`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2942,"value":"md `### Single-Site`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2202,"value":"title9 = md `### *Market Share: warehouse*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2205,"value":"$37","pinned":false,"hidden":false,"mode":"ojs"},{"id":2198,"value":"title8 = md `### *Market Share: lager*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2168,"value":"$38","pinned":false,"hidden":false,"mode":"ojs"},{"id":2939,"value":"md `### Multi-Site`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2272,"value":"title11 = md `### *Market Share: warehouse*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2269,"value":"$39","pinned":false,"hidden":false,"mode":"ojs"},{"id":2281,"value":"title12 = md `### *Market Share: lager*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2278,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs"},{"id":2966,"value":"md `## Unique competitors`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2631,"value":"vl.markLine({strokeWidth: 1.25, color: appc2_color_scheme[0], point: {fill: appc2_color_scheme[0], filled: true, stroke: 'white', size: 40}})\n .data(unique_competitors)\n .encode(\n vl.x().fieldT('date')\n .title(null),\n vl.y().fieldQ('distinct')\n .title('Distinct Competitors')\n )\n .config({\n view: { stroke: null },\n axis: {\n gridOpacity: 0.15,\n gridColor: 'grey',\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 domain: 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}\n )\n .padding({top: 25, bottom: 25, left: 20, right: 20})\n .width(1000).height(200)\n .render()","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":809,"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":2493,"value":"md `### *Country Filtering*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2397,"value":"data_countryFL = loaded_file.filter(d => d.country == country_selector)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1516,"value":"loaded_file = file.csv()","pinned":true,"hidden":false,"mode":"ojs"},{"id":3203,"value":"// duplicated the clean dataset above in order to not lose previous work\n\nclean_country = aq.from(data_countryFL)\n .derive({site_length: aq.escape( d => d.search_submarket.length )})\n .filter(d => d.site_length < 50)\n .derive({date: d => op.parse_date(d.date)})\n .groupby('date', 'company')\n .count()\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":3208,"value":"clean_country_market_pct = aq.from(clean_country)\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":3211,"value":"country_final_list = clean_country_market_pct.map(d => d.company)","pinned":true,"hidden":false,"mode":"ojs"},{"id":2108,"value":"### *Node Filtering*","pinned":false,"hidden":false,"mode":"md"},{"id":1105,"value":"clean_NodeFL = aq.from(data_countryFL)\n .derive({site_length: aq.escape( d => d.search_submarket.length )})\n .filter(d => d.site_length < 50)\n .filter(aq.escape( d => d.search_market == node_selector) )\n .reify()\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1117,"value":" clean = aq.from(clean_NodeFL)\n .derive({site_length: aq.escape( d => d.search_submarket.length )})\n .filter(d => d.site_length < 50)\n .derive({date: d => op.parse_date(d.date)})\n .groupby('date', 'company','keyword')\n .count()\n .groupby('keyword')\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":2889,"value":"// duplicated the clean dataset above in order to not lose previous work\n\nclean2 = aq.from(clean_NodeFL)\n .derive({site_length: aq.escape( d => d.search_submarket.length )})\n .filter(d => d.site_length < 50)\n .derive({date: d => op.parse_date(d.date)})\n .groupby('date', 'company')\n .count()\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":2840,"value":"clean_market_pct = aq.from(clean2)\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":2853,"value":"all_final_list = clean_market_pct.map(d => d.company)","pinned":true,"hidden":false,"mode":"ojs"},{"id":2112,"value":"### *Single Site Filtering*","pinned":false,"hidden":false,"mode":"md"},{"id":2095,"value":"// clean_siteFL = clean_NodeFL.filter(d => d.search_submarket == site_selector)","pinned":true,"hidden":false,"mode":"ojs"},{"id":2092,"value":"// clean_by_site = aq.from(clean_siteFL)\n// .derive({date: d => op.parse_date(d.date)}) \n// .groupby('date', 'search_submarket','company','keyword')\n// .count()\n// .groupby('keyword')\n// .derive({market_share: d => d.count/op.sum(d.count)})\n// .orderby(aq.desc('market_share'))\n// .filter(d => op.rank() <= 10)\n// .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":2905,"value":"// clean_by_site2 = aq.from(clean_siteFL)\n// .derive({date: d => op.parse_date(d.date)}) \n// .groupby('date', 'search_submarket','company') //,'keyword')\n// .count()\n// //.groupby('keyword')\n// .derive({market_share: d => d.count/op.sum(d.count)})\n// .orderby(aq.desc('market_share'))\n// .filter(d => op.rank() <= 10)\n// .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":2875,"value":"// clean_by_site_mk_pct = aq.from(clean_by_site2)\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":2878,"value":"// single_site_list = clean_by_site_mk_pct.map(d => d.company)","pinned":true,"hidden":false,"mode":"ojs"},{"id":2216,"value":"### *Multiple Site Filtering*","pinned":false,"hidden":false,"mode":"md"},{"id":2288,"value":"// multi_site_unique_list = uniqueValid(clean_NodeFL, d => d.search_submarket)","pinned":true,"hidden":false,"mode":"ojs"},{"id":2219,"value":"// // for multi sites, this code passes the array as a filter\n\n// clean_multi_site = clean_NodeFL.filter(d => mult_site_selector.includes(d.search_submarket))","pinned":true,"hidden":false,"mode":"ojs"},{"id":2232,"value":"// clean_by_multi_site = aq.from(clean_multi_site)\n// //.derive({date: d => op.parse_date(d.Date)}, {after: 'Date'})\n// .groupby('date', 'search_submarket','company','keyword')\n// .count()\n// .groupby('keyword')\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":2929,"value":"// clean_by_multi_site2 = aq.from(clean_multi_site)\n// //.derive({date: d => op.parse_date(d.Date)}, {after: 'Date'})\n// .groupby('date', 'search_submarket','company') //,'keyword')\n// .count()\n// //.groupby('keyword')\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":2931,"value":"// clean_by_multi_site_mk_pct = aq.from(clean_by_multi_site2)\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":2933,"value":"// multi_site_list_allK = clean_by_site_mk_pct.map(d => d.company)","pinned":true,"hidden":false,"mode":"ojs"},{"id":2575,"value":"md `### *Unique Competitors*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2577,"value":"unique_competitors = aq.from(clean_NodeFL)\n .derive({\n date: d => op.parse_date(d.date)}, {after: 'rank'\n })\n .groupby('date')\n .derive({\n distinct: d => op.distinct(d.company)\n })\n .select('date','distinct')\n .orderby('date')\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":2234,"value":"### Split for each keyword by multi site","pinned":false,"hidden":false,"mode":"md"},{"id":2243,"value":"*warehouse*","pinned":false,"hidden":false,"mode":"md"},{"id":2238,"value":"// wh_clean_Msite = aq.from(clean_by_multi_site)\n// .filter(d => d.keyword == 'warehouse')\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":2260,"value":"// wh_final_Msite_list = wh_clean_Msite.map(d => d.company)","pinned":true,"hidden":false,"mode":"ojs"},{"id":2249,"value":"*lager*","pinned":false,"hidden":false,"mode":"md"},{"id":2241,"value":"// uh_clean_Msite = aq.from(clean_by_multi_site)\n// .filter(d => d.keyword == 'lager')\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":2267,"value":"// uh_final_Msite_list = uh_clean_Msite.map(d => d.company)","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":1475,"value":"wh_clean = aq.from(clean)\n .filter(d => d.keyword == 'warehouse')\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":1679,"value":"final_list = wh_clean.map(d => d.company)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1563,"value":"*lager*","pinned":false,"hidden":false,"mode":"md"},{"id":1567,"value":"Inputs.table(uh_clean)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2446,"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 == 'lager')\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":2348,"value":"md `*picker packer*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2351,"value":"pp_clean = aq.from(clean)\n .filter(d => d.keyword == 'picker+packer')\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":2391,"value":"pp_final_list = pp_clean.map(d => d.company)","pinned":true,"hidden":false,"mode":"ojs"},{"id":2354,"value":"md `*disponent*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2359,"value":"Inputs.table(dis_clean)","pinned":true,"hidden":false,"mode":"ojs"},{"id":2357,"value":"dis_clean = aq.from(clean)\n .filter(d => d.keyword == 'disponent')\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":2455,"value":"dis_final_list = dis_clean.map(d => d.company)","pinned":true,"hidden":false,"mode":"ojs"},{"id":2134,"value":"### Split for each keyword by Site","pinned":false,"hidden":false,"mode":"md"},{"id":2150,"value":"*warehouse*","pinned":false,"hidden":false,"mode":"md"},{"id":2140,"value":"// wh_clean_site = aq.from(clean_by_site)\n// .filter(d => d.keyword == 'warehouse')\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":2144,"value":"// final_site_list = wh_clean_site.map(d => d.company)","pinned":true,"hidden":false,"mode":"ojs"},{"id":2154,"value":"*lager*","pinned":false,"hidden":false,"mode":"md"},{"id":2157,"value":"// uh_clean_site = aq.from(clean_by_site)\n// .filter(d => d.keyword == 'lager')\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":2465,"value":"// uh_final_site_list = uh_clean_site.map(d => d.company)","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.s_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(d => op.includes(op.lower(d.job_title), 'bonus'))\n// .groupby('date', 'company', 'job_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.job_title), 'benefits'))\n// .groupby('date', 'company', 'job_title')\n// .count()\n// .orderby('date')\n// .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":392,"value":"data = FileAttachment(\"Competitive Analysis - Workforce Staffing_Data Download for Aldo Template_Table (9).csv\").csv()","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":2670,"value":"two_weeks_back = d3.timeDay.offset(data_date_range[1], -14)","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":1670,"value":"companies = propArray('company')","pinned":true,"hidden":false,"mode":"ojs"},{"id":1668,"value":"propArray = curry(\n (prop, list) =>\n ({\n [prop]: map(k => k[prop], list)\n })\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1664,"value":"import {R, map, curry, merge, reduce, length, append, filter, sortWith, descend, ascend, take, pipe, compose, sum} from \"@martien/ramda\"","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: 'week',\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"},{"id":689,"value":"title6 = md `## Competitor Triggers`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2528,"value":"Inputs.bind(Inputs.select(loaded_file.map(d => d.country), {label: \"Select a Node\", unique: true, sort: true}), viewof country_selector)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2079,"value":"Inputs.bind(Inputs.select(data_countryFL.map(d => d.search_market), {label: \"Select a Node\", unique: true, sort: true}), viewof node_selector)","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W3b","stdlib":"1","titling":"auto"}