2b:null 2c:["$","title",null,{"children":"Konkurse | Office for Statistics and Data of the Canton of Zurich | Observable"}] 31:Tbd6,viewof totalKonkurse = vl .data(konkurse) .transform([ { calculate: "datum.kumsum > 0 ? 'Zunahme' : 'Abnahme'", as: "category" } ]) .facet({ field: "stichtag_quarter", type: "ordinal", columns: nCol, title: null }) .spec({ encoding: { x: { timeUnit: "year", field: "jahr", type: "ordinal" }, y: { aggregate: "sum", field: "kumsum", axis: { title: null, grid: true, gridColor: { condition: { test: "datum.value === 0", value: "transparent" }, value: "#fff" } }, scale: { domain: [0, extentKumsum * 1.1] } } }, layer: [ { mark: { type: "bar" }, encoding: { color: { timeUnit: "year", field: "jahr", type: "ordinal", scale: { range: ["#219ebc", "#219ebc", "#023047"] // blues: ["#8ecae6", "#219ebc", "#023047", "#ffb703", "#fb8500"] }, title: null, legend: null } } }, { mark: { type: "text" }, encoding: { text: { field: "kumsum", type: "quantitative" } } } ] }) .columns(nCol) .title({ text: "Kumulierte Anzahl Konkurse pro Quartal", subtitle: "Kanton Zürich" }) .autosize({ type: "fit", resize: true }) .config({ locale: { number: locale }, view: { fill: "#e5e5e5", stroke: "transparent", width: plotWidth(4), height: 350 }, scale: { bandPaddingInner: 0.2, bandPaddingOuter: 0.2 }, background: "#ffffff", axis: { labelFontSize: 12, labelFont: ZHFonts.regular, labelColor: "black", titleFontSize: 12, titleColor: "black", titleFont: ZHFonts.regular }, axisX: { labelAngle: 0, labelPadding: 7, title: null, orient: "bottom", ticks: false, labelFont: ZHFonts.black, labelFontSize: 12, tickCount: { signal: Math.ceil(plotWidth(4) / 80) } }, axisY: { axis: "right", grid: true, ticks: true, tickCount: { signal: Math.ceil(350 / 80) } }, title: { font: ZHFonts.black, fontSize: 16, offset: 15, anchor: "start", lineHeight: 5, padding: 40, subtitleFont: ZHFonts.regular, subtitleFontSize: 14 }, header: { labelOrient: "top", labelPadding: 5, lineHeight: 3, labelFontSize: 13, labelFont: ZHFonts.black, labelColor: "black" }, legend: { orient: "top", labelFontSize: 14, labelFont: ZHFonts.regular, labelColor: "black", labelLimit: 300, columns: nCol, rowPadding: 5, title: null }, text: { font: ZHFonts.regular, fontSize: 14, color: "white", dy: 15 } }) .render()32:Tbb8,viewof anzahlKonkurse = vl .data(konkurse) .transform([ { calculate: "datum.n > 0 ? 'Zunahme' : 'Abnahme'", as: "category" } ]) .facet({ field: "stichtag_quarter", type: "ordinal", columns: nCol, title: null }) .spec({ encoding: { x: { timeUnit: "year", field: "jahr", type: "ordinal" }, y: { aggregate: "sum", field: "n", axis: { title: null, grid: true, gridColor: { condition: { test: "datum.value === 0", value: "transparent" }, value: "#fff" } }, scale: { domain: [0, extentN * 1.1] } } }, layer: [ { mark: { type: "bar" }, encoding: { color: { timeUnit: "year", field: "jahr", type: "ordinal", scale: { range: ["#219ebc", "#219ebc", "#023047"] // blues: ["#8ecae6", "#219ebc", "#023047", "#ffb703", "#fb8500"] }, title: null, legend: null } } }, { mark: { type: "text" }, encoding: { text: { field: "n", type: "quantitative" } } } ] }) .columns(nCol) .title({ text: "Anzahl Konkurse pro Quartal", subtitle: "Kanton Zürich" }) .autosize({ type: "fit", resize: true }) .config({ locale: { number: locale }, view: { fill: "#e5e5e5", stroke: "transparent", width: plotWidth(4), height: 350 }, scale: { bandPaddingInner: 0.2, bandPaddingOuter: 0.2 }, background: "#ffffff", axis: { labelFontSize: 12, labelFont: ZHFonts.regular, labelColor: "black", titleFontSize: 12, titleColor: "black", titleFont: ZHFonts.regular }, axisX: { labelAngle: 0, labelPadding: 7, title: null, orient: "bottom", ticks: false, labelFont: ZHFonts.black, labelFontSize: 12, tickCount: { signal: Math.ceil(plotWidth(4) / 80) } }, axisY: { axis: "right", grid: true, ticks: true, tickCount: { signal: Math.ceil(350 / 80) } }, title: { font: ZHFonts.black, fontSize: 16, offset: 15, anchor: "start", lineHeight: 5, padding: 40, subtitleFont: ZHFonts.regular, subtitleFontSize: 14 }, header: { labelOrient: "top", labelPadding: 5, lineHeight: 3, labelFontSize: 13, labelFont: ZHFonts.black, labelColor: "black" }, legend: { orient: "top", labelFontSize: 14, labelFont: ZHFonts.regular, labelColor: "black", labelLimit: 300, columns: nCol, rowPadding: 5, title: null }, text: { font: ZHFonts.regular, fontSize: 14, color: "white", dy: 15 } }) .render()33:Tcc8,viewof vorjahresvergleichKonkurse = vl .data(konkurse) .transform([ { calculate: "datum.ytd > 0 ? 'Zunahme' : 'Abnahme'", as: "category" } ]) .facet({ field: "stichtag_quarter", type: "ordinal", columns: nCol, title: null }) .spec({ encoding: { x: { timeUnit: "year", field: "jahr", type: "ordinal" }, y: { aggregate: "sum", field: "ytd", axis: { format: "+%", title: null, grid: true, gridColor: { condition: { test: "datum.value === 0", value: "#000" }, value: "#fff" } }, scale: { domain: extentYTD } } }, layer: [ { mark: { type: "bar" }, encoding: { color: { field: "category", type: "ordinal", scale: { range: ["#ff8500", "#5a189a"] // blues: ["#8ecae6", "#219ebc", "#023047", "#ffb703", "#fb8500"] }, title: null, legend: "top" } } }, { mark: { type: "text", // align: { expr: "datum.ytd < 0 ? 'middle' : 'middle'" }, dy: { expr: "datum.ytd < 0 ? 12.5 : -12.5" } }, encoding: { text: { field: "ytd", type: "quantitative", format: "+.0%" }, color: { condition: { test: "datum.ytd < 0", value: "#000" }, value: "#000" } } } ] }) .columns(nCol) .title({ text: "Veränderung zum Vorjahresquartal, in Prozent", subtitle: "Kanton Zürich, Basis: Anzahl Konkurse" }) .autosize({ type: "fit", resize: true }) .config({ locale: { number: locale }, view: { fill: "#e5e5e5", stroke: "transparent", width: plotWidth(4), height: 350 }, scale: { bandPaddingInner: 0.2, bandPaddingOuter: 0.2 }, background: "#ffffff", axis: { labelFontSize: 12, labelFont: ZHFonts.regular, labelColor: "black", titleFontSize: 12, titleColor: "black", titleFont: ZHFonts.regular }, axisX: { labelAngle: 0, labelPadding: 7, title: null, orient: "bottom", ticks: false, labelFont: ZHFonts.black, labelFontSize: 12, tickCount: { signal: Math.ceil(plotWidth(4) / 80) } }, axisY: { axis: "right", grid: true, ticks: true, tickCount: { signal: Math.ceil(350 / 80) } }, title: { font: ZHFonts.black, fontSize: 16, offset: 15, anchor: "start", lineHeight: 5, padding: 40, subtitleFont: ZHFonts.regular, subtitleFontSize: 14 }, header: { labelOrient: "top", labelPadding: 5, lineHeight: 3, labelFontSize: 13, labelFont: ZHFonts.black, labelColor: "black" }, legend: { orient: "top", labelFontSize: 14, labelFont: ZHFonts.regular, labelColor: "black", labelLimit: 300, columns: nCol, rowPadding: 5, title: null }, text: { font: ZHFonts.regular, fontSize: 14 } }) .render()34:T4fd,drawGroupedBarChart = function (daten, facet_field, title, y_value) { const plot = vl .data(daten) // .transform({ // filter: "datum.stichtag_quarter == '06-30' " // }) .layer( vl .markBar({ cornerRadiusTopRight: 3, cornerRadiusTopLeft: 3 }) .encode( vl.column().fieldO(facet_field).timeUnit("utcmonth").title(null), vl.x().fieldN("jahr").axis({ title: null }), vl.y().sum(y_value).axis(null), vl .color({ legend: null }) .fieldN("jahr") .scale({ range: ["#219ebc", "#219ebc", "#023047"] // blues: ["#8ecae6", "#219ebc", "#023047", "#ffb703", "#fb8500"] }) ), vl .markText({ align: "center", fill: "white", fontWeight: "bold", fontSize: 12, dy: 15 }) .encode( vl.column().fieldO(facet_field).timeUnit("utcmonth").title(null), vl.x().fieldN("jahr"), vl.y().sum(y_value), vl.text({ baseline: "middle", field: `${y_value}` }) ) ) .title({ text: title, anchor: "middle", fontSize: 13 }); return plot; }35:[] 2f:{"id":"08aa1b236446c039","slug":null,"title":"Konkurse","thumbnail":"09efb3b29c6ebf08c8bd85c4d1ee2c5052a5ae1cfc5a883595933ca2d20c8731","access_level":"public","create_time":"$D2022-05-22T06:46:53.592Z","update_time":"$D2024-09-05T05:40:47.265Z","view_time":null,"first_public_time":"$D2022-10-26T05:56:32.600Z","has_unpublished_edits":null,"fork":{"id":"2a81afdc2420b7ac","slug":null,"title":"Löschungen","owner":{"id":"4b23743d6fe05d13","login":"statistikzh","name":"Office for Statistics and Data of the Canton of Zurich"}},"stars":0,"starred":false,"owner":{"type":"team","id":"4b23743d6fe05d13","login":"statistikzh","name":"Office for Statistics and Data of the Canton of Zurich","avatar_url":"https://avatars-next.observableusercontent.com/61364635cd5db7a914727e7625ac41daa90fedeba239e3d2ce93b57a9ad3bce9","tier":"pro"},"version":2400,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"32d8f5276b0e4535","login":"cgrb","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a7d9a10b8456291ccefbc9c7c7b9ecdc5d5f31095c0a77bdea09bd75590057bc","tier":null}],"members":[{"type":"individual","id":"32d8f5276b0e4535","login":"cgrb","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a7d9a10b8456291ccefbc9c7c7b9ecdc5d5f31095c0a77bdea09bd75590057bc","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Konkurse","cells":[{"id":2239,"value":"# Konkurse\n\nOpen Data ⤓ [Konkurse pro Quartal und Branchen ab 2018](https://www.zh.ch/de/politik-staat/statistik-daten/datenkatalog.html#/datasets/1421@handelsregisteramt-kanton-zuerich/distributions/2780)\n\nThemenseite auf zh.ch: [Zahlen & Fakten zu Eintragungen im Handelsregister](https://www.zh.ch/de/wirtschaft-arbeit/handelsregister/zahlen-fakten.html#main_linklist)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2284,"value":"konkurseTotal = (function () {\n if (konkurseSelection == \"Anzahl\") {\n return htl.html`\n${viewof konkurseSelection}\n
\n${viewof anzahlKonkurse}`;\n } else if (konkurseSelection == \"Kumulierte Anzahl\") {\n return htl.html`\n${viewof konkurseSelection}\n
\n${viewof totalKonkurse}`;\n } else if (konkurseSelection == \"Veränderung\") {\n return htl.html`\n${viewof konkurseSelection}\n
\n${viewof vorjahresvergleichKonkurse}`;\n }\n})()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2375,"value":"---\n### Code für Plots","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2281,"value":"viewof konkurseSelection = Inputs.radio(\n [\"Anzahl\", \"Kumulierte Anzahl\", \"Veränderung\"],\n {\n label: \"Datensicht wechseln\",\n value: \"Anzahl\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2249,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2255,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2261,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1845,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":894,"value":"-----\n## Daten","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2320,"value":"data = d3.csv(\n \"https://www.web.statistik.zh.ch/ogd/data/KANTON_ZUERICH_HRA_Konkurse.csv\",\n { typed: true }\n)\n\n// FileAttachment(\"data_konkurs@2.csv\").csv({ typed: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"konkurse = tidy(\n data,\n filter((d) => d.branchen == \"Total\" && d.jahr >= mostRecentYear - 2),\n mutate({\n ytd: (d) => +d.vj_rel_n,\n n: (d) => +d.n,\n kumsum: (d) => +d.kumsum,\n jahr: (d) => d.jahr.toString(),\n stichtag_quarter: (d) => d.quartal\n })\n) // .sort(function (a, b) { return a.n - b.n;})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2051,"value":"mostRecentYear = d3.max(data, (d) => d.jahr)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2220,"value":"extentYTD = (function (d) {\n const minNetflow = d3.min(konkurse, (d) => d.ytd);\n const maxNetflow = d3.max(konkurse, (d) => d.ytd);\n\n if (minNetflow < 0 && 0 - minNetflow > maxNetflow - 0) {\n return [minNetflow * 1.25, (0 - minNetflow) * 1.25];\n } else if (minNetflow < 0 && 0 - minNetflow < maxNetflow - 0) {\n return [(0 - maxNetflow) * 1.25, maxNetflow * 1.25];\n } else if (minNetflow > 0 && 0 - minNetflow < maxNetflow - 0) {\n return [(0 - maxNetflow) * 1.25, maxNetflow * 1.25];\n }\n})()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2267,"value":"extentKumsum = d3.max(konkurse, (d) => d.kumsum)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2269,"value":"extentN = d3.max(konkurse, (d) => d.n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"---\n### Code for Formatting","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":142,"value":"// Sets the locale for Vega-Lite axis, but not for text in tooltip (CMS does not recognise)\nlocale = await d3.json(\n \"https://cdn.jsdelivr.net/npm/d3-format@3/locale/de-CH.json\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"plotWidth = function (nPlots) {\n if (nPlots == 1) {\n // Entspricht Mobile\n if (width < 415) {\n return width * 0.88;\n } else if (width >= 415 && width < 768) {\n return width * 0.855;\n // Entspricht Tablets\n } else if (width >= 768 && width <= 1248) {\n return width * 0.877;\n // Entspricht Laptops & Desktops\n } else {\n return 1128 * 0.9275;\n }\n } else {\n // Entspricht Mobile\n if (width < 768) {\n return (width * 1.4) / nPlots;\n // Entspricht Tablets\n } else if (width >= 768 && width <= 1248) {\n return (width * 1.6) / nPlots;\n // Entspricht Laptops & Desktops\n } else {\n return (1128 * 0.92) / nPlots;\n }\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":53,"value":"nCol = {\n if (width >= 1100) {\n return 4;\n } else if (width < 1100 && width >= 750) {\n return 2;\n } else {\n return 1;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"---\n### Dependencies","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2390,"value":"import { fonts as ZHFonts } from \"@statistikzh/common-styles\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"import { tidy, mutate, filter } from \"@pbeshai/tidyjs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"import { vl } from \"@vega/vega-lite-api-v5\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 30:"$2f:body"