2b:null 2c:["$","title",null,{"children":"Schedule Result Viewer | jiguangxia | Observable"}] 31:T27ac,chart = { const brush = vl.selectSingle().encodings('x').fields('real_label','plan_label'); // SKU分布趋势图 const plot = vl.markBar().resolve({scale: {y: y_independent}}).title('SKU分布趋势图') .data(data) .encode( vl.x().timeYMD('dt').fieldT('dt').axis({title: null, format: "%m-%d", labelAngle: 90, tickCount: 'day'}).scale({domain: date_range}), vl.y().distinct('sku_id').axis({title: null}), vl.color().fieldN('real_label').title(null).scale({domain:['不生效','生效'], range: ['#3c6497', '#f07115']}), vl.facet().field('plan_label').columns(1).title(null), vl.tooltip([{field: "dt", type: "temporal", format: "%Y-%m-%d %A", title:"日期"}, {field: "real_label", title:"真实状态"}, {field: "sku_id", aggregate: "distinct", title:"商品数量"} ]) ) .select(brush) .width(500) .height(100) ; // 下探分析 const reason_plot = vl.markBar().title('原因下探(点击上图)') .data(data) .transform({filter:brush}) .encode( vl.y().fieldN('plan_reason').axis({title: null}), vl.x().distinct('sku_id').axis({title: null}), vl.color().fieldN('real_label').scale({domain:['不生效','生效'], range: ['#3c6497', '#f07115']}), vl.tooltip([{field: "sku_id", aggregate: "distinct", title:"商品数量"}]) ) .width(500) .height(200) ; // 闪购品牌分布(rect) const brand_data = data.filter(d=>d.plan_label=='1.当天建议' && d.source_id=='5'); let brands = new Set(brand_data.map(d=>d.main_brand_code)); const brand_plot_rect = vl.markRect().title('算法建议商品(+手动新增-手动剔除)——闪购品牌分布') .data(brand_data) .encode( vl.y().fieldN('main_brand_name').title(null), vl.x().timeYMD('dt').fieldT('dt').axis({title: null, format: "%m-%d", labelAngle: 45, labelOffset:5, tickCount: 'day'}).scale({domain: date_range}), vl.color().distinct('sku_id').title(null).legend(null), vl.tooltip([{field: "dt", type: "temporal", format: "%Y-%m-%d %A", title:"日期"}, {field: "main_brand_code", title:"品牌编码"}, {field: "main_brand_name", title:"品牌名称"}, {field: "sku_id", aggregate: "distinct", title:"商品数量"} ]) ) .width(600) .height(brands.size * 20) ; // 闪购品牌分布(value) const brand_plot_value = vl.markText({align:'left', baseline: 'middle', dx: 10}).title(null) .data(brand_data) .encode( vl.y().fieldN('main_brand_name').title(null), vl.x().timeYMD('dt').fieldT('dt').axis({title: null, format: "%m-%d", labelAngle: 45, labelOffset:5, tickCount: 'day'}).scale({domain: date_range}), vl.text().distinct('sku_id').title(null), vl.color().value('#ff7777') ) .width(600) .height(brands.size * 20) ; // 闪购品牌分布(rect+value) const brand_plot = vl.layer(brand_plot_rect, brand_plot_value); // 采销分布(rect) const sug_data = data.filter(d=>d.plan_label=='1.当天建议'); let salers = new Set(sug_data.map(d=>d.saler_erp)); const saler_plot_rect = vl.markRect().title('算法建议商品(+手动新增-手动剔除)——采销分布') .data(sug_data) .encode( vl.y().fieldN('saler_name').title(null), vl.x().timeYMD('dt').fieldT('dt').axis({title: null, format: "%m-%d", labelAngle: 45, labelOffset:5 , tickCount: 'day'}).scale({domain: date_range}), vl.color().distinct('sku_id').title(null).legend(null), vl.tooltip([{field: "dt", type: "temporal", format: "%Y-%m-%d %A", title:"日期"}, {field: "saler_erp", title:"销售员ERP"}, {field: "saler_name", title:"销售员姓名"}, {field: "sku_id", aggregate: "distinct", title:"商品数量"} ]) ) .width(600) .height(salers.size * 20) ; // 采销分布(value) const saler_plot_value = vl.markText({align:'left', baseline: 'middle', dx: 10}).title(null) .data(sug_data) .encode( vl.y().fieldN('saler_name').title(null), vl.x().timeYMD('dt').fieldT('dt').axis({title: null, format: "%m-%d", labelAngle: 45, labelOffset:5, tickCount: 'day'}).scale({domain: date_range}), vl.text().distinct('sku_id').title(null), vl.color().value('#ff7777') ) .width(600) .height(salers.size * 20) ; // 采销分布(rect+value) const saler_plot = vl.layer(saler_plot_rect, saler_plot_value); // 场域分布 const source_plot_bar = vl.markBar().title('算法建议商品(+手动新增-手动剔除)——频道分布') .data(sug_data) .encode( vl.x().timeYMD('dt').fieldT('dt').axis({title: null, format: "%m-%d", labelAngle: 45, labelOffset:5, tickCount: 'day'}).scale({domain: date_range}), vl.y().distinct('sku_id').axis({title: null}), vl.color().fieldN('source_id').title(null).scale({domain:['4','5'], range: ['#f22021', '#2021f2']}), vl.opacity().value(0.6), vl.tooltip([{field: "dt", type: "temporal", format: "%Y-%m-%d %A", title:"日期"}, {field: "source_id", title:"频道"}, {field: "sku_id", aggregate: "distinct", title:"商品数量"}, ]) ) .width(600) .height(100) ; // 场域分布(value) const source_plot_value = vl.markText({align:'left', baseline: 'bottom', dx: 10}).title(null) .data(sug_data) .encode( vl.x().timeYMD('dt').fieldT('dt').axis({title: null, format: "%Y-%m-%d", labelAngle: 45, labelOffset:5, tickCount: 'day'}).scale({domain: date_range}), vl.y().distinct('sku_id').stack(true).axis({title: null}), vl.color().fieldN('source_id').title(null), vl.text({field: "sku_id", aggregate: "distinct", title:"商品数量"}) ) .width(600) .height(100) ; // 场域分布(bar+value) const source_plot = vl.layer(source_plot_bar, source_plot_value) // Band分布 const band_plot_rect = vl.markRect().title('算法建议商品(+手动新增-手动剔除)——销量band分布') .data(sug_data) .encode( vl.x().timeYMD('dt').fieldT('dt').axis({title: null, format: "%m-%d", labelAngle: 45, labelOffset:5, tickCount: 'day'}).scale({domain: date_range}), vl.y().fieldN('sale_qtty_band_day28').title(null), vl.color().distinct('sku_id').title(null).legend(null), vl.tooltip([{field: "dt", type: "temporal", format: "%Y-%m-%d %A", title:"日期"}, {field: "sale_qtty_band_day28", title:"销量band(28天cid3)"}, {field: "sku_id", aggregate: "distinct", title:"商品数量"} ]) ) .width(600) .height(100) ; // Band分布(value) const band_plot_value = vl.markText({align:'left', baseline: 'middle', dx: 10}).title(null) .data(sug_data) .encode( vl.x().timeYMD('dt').fieldT('dt').axis({title: null, format: "%m-%d", labelAngle: 45, labelOffset:5, tickCount: 'day'}).scale({domain: date_range}), vl.y().fieldN('sale_qtty_band_day28').title(null), vl.text().distinct('sku_id').title(null), vl.color().value('#ff7777') ) .width(600) .height(100) ; // band分布(bar+value) const band_plot = vl.layer(band_plot_rect, band_plot_value); // 提报分布 const apply_plot_bar = vl.markBar().title('算法建议商品(+手动新增-手动剔除)——提报信息') .data(sug_data) .encode( vl.x().timeYMD('dt').fieldT('dt').axis({title: null, format: "%m-%d", labelAngle: 45, labelOffset:5, tickCount: 'day'}).scale({domain: date_range}), vl.y().distinct('sku_id').axis({title: null}), vl.color().fieldN('apply_label').title(null).scale({domain:['提报','未提报'], range: ['#3c6497', '#999999']}), vl.tooltip([{field: "dt", type: "temporal", format: "%Y-%m-%d %A", title:"日期"}, {field: "apply_label", title:"提报信息"}, {field: "sku_id", aggregate: "distinct", title:"商品数量"}, ]) ) .width(600) .height(100) ; // 提报分布(value) const apply_plot_value = vl.markText({align:'left', baseline: 'bottom', dx: 10}).title(null) .data(sug_data) .encode( vl.x().timeYMD('dt').fieldT('dt').axis({title: null, format: "%Y-%m-%d", labelAngle: 45, labelOffset:5, tickCount: 'day'}).scale({domain: date_range}), vl.y().distinct('sku_id').stack(true).axis({title: null}), vl.color().fieldN('apply_label').title(null), vl.text({field: "sku_id", aggregate: "distinct", title:"商品数量"}) ) .width(600) .height(100) ; // 提报分布(bar+value) const apply_plot = vl.layer(apply_plot_bar, apply_plot_value) //生效来源分布(rect) const promo_data = data.filter(d=>d.real_label=='生效'); const promo_plot_rect = vl.markRect().title('生效商品——组成') .data(promo_data) .encode( vl.x().timeYMD('dt').fieldT('dt').axis({title: null, format: "%m-%d", labelAngle: 45, labelOffset:5, tickCount: 'day'}).scale({domain: date_range}), vl.y().fieldN('plan_label').title(null), vl.color().distinct('sku_id').legend(null), vl.opacity().value(0.6), vl.tooltip([{field: "dt", type: "temporal", format: "%Y-%m-%d %A", title:"日期"}, {field: "plan_label", title:"算法建议"}, {field: "sku_id", aggregate: "distinct", title:"商品数量"}, ]) ) .width(600) .height(100) ; // 生效来源分布(value) const promo_plot_value = vl.markText({align:'left', baseline: 'middle', dx: 10}).title(null) .data(promo_data) .encode( vl.x().timeYMD('dt').fieldT('dt').axis({title: null, format: "%m-%d", labelAngle: 45, labelOffset:5, tickCount: 'day'}).scale({domain: date_range}), vl.y().fieldN('plan_label').title(null), vl.text().distinct('sku_id').title(null), vl.color().value('#ff7777') ) .width(600) .height(100) ; // 生效来源分布(bar+value) const promo_plot = vl.layer(promo_plot_rect, promo_plot_value) // 组合结果 let col1 = []; if (promo_data.length>0) { col1.push(promo_plot); } if (sug_data.length>0) { col1 = col1.concat([apply_plot, source_plot, band_plot, brand_plot, saler_plot]); } return vl.hconcat([ vl.vconcat(col1).spacing(20), vl.vconcat([plot, reason_plot]) ]).render(); }32:[] 2f:{"id":"73ecb7da8ba066e1","slug":"schedule-result-viewer","title":"Schedule Result Viewer","thumbnail":"bcf17b215eed8a08fd1fb28d2887ad8088584442413940c57e52955247fcec44","access_level":"public","create_time":"$D2022-02-23T06:35:26.407Z","update_time":"$D2022-03-30T03:07:22.803Z","view_time":null,"first_public_time":"$D2022-02-24T03:29:10.131Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"858f5272e98bbb9a","login":"jiguangxia","name":"","avatar_url":"https://avatars-next.observableusercontent.com/60e42f279aa366fac172c30fd4911a9c9e55e32deb51212969b5ca61e0d9d662","tier":"starter_2024"},"version":918,"publish_version":918,"role":null,"authored":false,"authors":[{"type":"individual","id":"dc1871c09bcdd579","login":"jiguangxia","name":"","avatar_url":"https://avatars-next.observableusercontent.com/60e42f279aa366fac172c30fd4911a9c9e55e32deb51212969b5ca61e0d9d662","tier":null}],"members":[{"type":"individual","id":"dc1871c09bcdd579","login":"jiguangxia","name":"","avatar_url":"https://avatars-next.observableusercontent.com/60e42f279aa366fac172c30fd4911a9c9e55e32deb51212969b5ca61e0d9d662","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Schedule Result Viewer","cells":[{"id":0,"value":"# Schedule Result Viewer","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":407,"value":"## 1. 下载数据明细","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":192,"value":"viewof object = formWithSumbit(html``)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":411,"value":"## 2. 导入文件，浏览排期结果","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":371,"value":"viewof file = html``;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"viewof selected_label = checkbox({options: ['生效','不生效'], value: ['生效','不生效'], title: \"只展示以下商品\"});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":173,"value":"viewof selected_source = checkbox({options: [ {value: \"4\", label: \"品类秒杀\" }, {value: \"5\", label: \"品牌闪购\" }], value: ['4'], title: \"只展示以下频道\"});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":876,"value":"viewof selected_saler = select({\n options: ['全部'].concat([...all_salers].sort()),\n title: '选择采销'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":888,"value":"viewof selected_brand = select({\n options: ['全部'].concat([...all_brands].sort()),\n title: '选择品牌'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":859,"value":"viewof selected_dept = select({\n options: ['全部'].concat([...all_depts].sort()),\n title: '选择部门'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":761,"value":"viewof y_independent = radio({options: [{value: 'independent', label: \"独立\"}, {value: 'shared', label: \"共享\" }], value: 'independent', title: \"坐标轴设置\"});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":517,"value":"DOM.download(serialize(data_download), '排期日历', \"下载SKU排期日历\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":189,"value":"viewof table = Inputs.table(data_download, {})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"# Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":12,"value":"d3 = require('d3@6')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"import {vl} from '@vega/vega-lite-api';","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":80,"value":"import {checkbox, radio, date, autoSelect, select} from \"@jashkenas/inputs\";","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":194,"value":"import {formWithSumbit} from \"@forresto/form-input-with-submit\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":510,"value":"import {serialize} from \"@palewire/saving-csv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":324,"value":"{\n if (object) {\n let url = 'http://127.0.0.1:5000/csv_url?access_key='+object.accesskey+'&signature='+object.signature+'&cid3='+object.cid3;\n let res = await fetch(url);\n let text = await res.text();\n d3.select('form.my').select('a').attr('href', text).text('已生成，点击下载: ' + text);\n } else {\n d3.select('form.my').select('a').text('');\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":366,"value":"all_data = {\n if (file === undefined) {\n return [];\n } else {\n return d3.csv(URL.createObjectURL(file));\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":610,"value":"data = {\n let tmp_data = all_data.filter(d => selected_label.includes(d.real_label) && selected_source.includes(d.source_id));\n if (selected_saler != '全部') {\n tmp_data = tmp_data.filter(d => d.saler_erp==selected_saler);\n }\n if (selected_brand != '全部') {\n tmp_data = tmp_data.filter(d => d.main_brand_name==selected_brand);\n }\n if (selected_dept != '全部') {\n tmp_data = tmp_data.filter(d => d.dept_name_2==selected_dept);\n }\n return tmp_data;\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":524,"value":"data_download = {\n let all_dts = Array.from(d3.group(data, d => d.dt).keys()).sort();\n let res = d3.rollup(data.filter(d=>d.plan_label=='1.当天建议'), v => v.map(d=>d.source_id).join(','), d => d.sku_id, d => d.dt);\n let res_matrix = [];\n for (let sku_id of res.keys()) {\n let sku_obj = sku_info.get(sku_id);\n for (let dt of all_dts) {\n sku_obj[dt] = res.get(sku_id).get(dt) || '0';\n }\n res_matrix.push(sku_obj);\n }\n return res_matrix;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":654,"value":"sku_info = d3.rollup(data.filter(d=>d.plan_label=='1.当天建议'), v => ({\n sku_id: v[0].sku_id,\n erp: v[0].saler_erp,\n 采销: v[0].saler_name,\n 商品名称: v[0].sku_name,\n 品牌: v[0].main_brand_name,\n 品牌code: v[0].main_brand_code,\n 销量Band7日: v[0].sale_qtty_band_day7,\n 销量Band28日: v[0].sale_qtty_band_day28,\n 七天最低价: v[0].min_price_7,\n 秒杀次数: v[0].ms_count,\n 近30日出库销量: parseFloat(v[0].out_wh_sale_qtty_day30_drop),\n 厂商直送: v[0].vender_direct_delv_flag,\n 库存量: parseFloat(v[0].usable_inv_qtty),\n 可售天数: parseFloat(v[0].est_sale_day),\n 缺货仓数: v[0].outstock_dc_num,\n}), d => d.sku_id);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":731,"value":"date_range = {\n let dt_range = d3.extent(all_data.map(d=>d.dt));\n let start_date = dt_range[0] + ' 00:00:00';\n let end_date = dt_range[1] + ' 24:00:00';\n return [start_date, end_date]\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":812,"value":"all_salers = new Set(all_data.map(d=>d.saler_erp));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":837,"value":"all_brands = new Set(all_data.map(d=>d.main_brand_name));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":841,"value":"all_depts = new Set(all_data.map(d=>d.dept_name_2));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 30:"$2f:body"