30:T4db,title = htl.html`

Economic Sentiment Indicator vom ${monat} ${jahr}

Im ${monat} ${jahr} ging der Indikator der wirtschaftlichen Einschätzung (ESI) sowohl in der EU (${EU_ESI_diff.toString().replace(".", ",")} Punkte auf ${EU_ESI_aktuell.toString().replace(".", ",")}) als auch im Euroraum (${EA_ESI_diff.toString().replace(".", ",")} Punkte auf ${EU_ESI_aktuell.toString().replace(".", ",")} Punkte) geringfügig zurück. Der Indikator der Beschäftigungserwartungen (EEI) sank in beiden Gebieten etwas deutlicher (EU: ${EU_EEI_diff.toString().replace(".", ",")} Punkte auf ${EU_EEI_aktuell.toString().replace(".", ",")} Punkte, Euroraum: ${EA_EEI_diff.toString().replace(".", ",")} Punkte auf ${EA_EEI_aktuell.toString().replace(".", ",")} Punkte). Im Gegensatz zum ESI lag der EEI weiterhin über seinem langfristigen Durchschnitt. Angezeigt wird der ${selectSeriesValue} vom ${monate[Zeitraum[selectMonatValue - 1].date.getMonth()]} ${1900 + Zeitraum[selectMonatValue - 1].date.getYear()}.

PDF-Download `31:T496,title_en = htl.html`

Economic Sentiment Indicator for ${monat} ${jahr}

In ${monat} ${jahr}, the Economic Sentiment Indicator (ESI) slightly decreased both in the EU (${EU_ESI_diff.toString().replace(".", ",")} points to ${EU_ESI_aktuell.toString().replace(".", ",")}) and in the Euro area (${EA_ESI_diff.toString().replace(".", ",")} points to ${EU_ESI_aktuell.toString().replace(".", ",")} points). The Employment Expectations Indicator (EEI) decreased somewhat more significantly in both regions (EU: ${EU_EEI_diff.toString().replace(".", ",")} points to ${EU_EEI_aktuell.toString().replace(".", ",")} points, Euro area: ${EA_EEI_diff.toString().replace(".", ",")} points to ${EA_EEI_aktuell.toString().replace(".", ",")} points). Unlike the ESI, the EEI remained above its long-term average. Displayed is the ${selectSeriesValue} from ${monate[Zeitraum[selectMonatValue - 1].date.getMonth()]} ${1900 + Zeitraum[selectMonatValue - 1].date.getYear()}.

PDF Download `32:T579,config = ({ mark: { tooltip: null }, view: { stroke: null }, font: "FFDaxPro", fontSize: 14, concat: { spacing: 20 }, title: { offset: 0, fontSize: 16, subtitleFontSize: 14, }, axis: { labelFontSize: 14, titleFontSize: 14, titleFontWeight: "normal", }, legend: { labelFontSize: 14, titleFontSize: 14, titleFontWeight: "normal", }, mark: { fontSize: 14 }, locale: { number: { decimal: ",", thousands: ".", grouping: [3] }, time: { dateTime: "%A %e %B %Y, %X", date: "%d/%m/%Y", time: "%H:%M:%S", periods: ["AM", "PM"], days: [ "Montag", "Dienstag", "Mittwoch", "Donnerstag", "Freitag", "Samstag", "Sonntag" ], shortDays: [ "Mo", "Di", "Mi", "Do", "Fr", "Sa", "So" ], months: [ "Jänner", "Februar", "März", "April", "Mai", "Juni", "Juli", "August", "September", "Oktober", "November", "Dezember" ], shortMonths: [ "Jän", "Feb", "Mrz", "Apr", "Mai", "Jun", "Jul", "Aug", "Sep", "Okt", "Nov", "Dez" ] } }, })33:Ta6c,34:[] 2e:{"title":"Economic Sentiment Indicator","cells":[{"id":0,"value":"# Economic Sentiment Indicator","pinned":false,"hidden":false,"mode":"md"},{"id":630,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":1676,"value":"viewof toggle = Inputs.toggle({label: \"Zeige SERV73 statt Indikatorauswahl\", value: false})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1247,"value":"selections = htl.html`\n

\n ${selectSeries}\n

\n ${selectScale}\n

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":947,"value":"graph = width > 1000 ? \n htl.html`\n

\n ${view}\n ${selectMonat}\n

${facets}

${source}

\n ` :\n htl.html`\n

${view}

${source}

\n ` ","pinned":false,"hidden":false,"mode":"ojs"},{"id":452,"value":"---\n# Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":1699,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":1688,"value":"source = \"Q: © Economic Sentiment Indicator (ESI) der Europäischen Kommission DG-ECFIN; Kartendaten: © Eurostat bezüglich der Verwaltungsgrenzen; Visualisierung: Österreichisches Institut für Wirtschaftsforschung (WIFO).\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1691,"value":"source_en = \"Source: © Economic Sentiment Indicator (ESI) of the European Commission DG-ECFIN; Map data: © Eurostat regarding administrative boundaries; Visualization: Austrian Institute of Economic Research (WIFO).\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":321,"value":"selectScale = Inputs.select([\"Aktuelle Abweichungen\", \"Gesamtzeitraum\"], {label: \"Farbskalierung\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":198,"value":"selectSeries = Inputs.select(\n seriesNames, \n {\n label: \"Indikator\",\n value: \"ESI\",\n width: 200,\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1796,"value":"formatDate = {\n // const locale = await d3.json(\"https://cdn.jsdelivr.net/npm/d3-time-format@4/locale/de-DE.json\");\n // d3.timeFormatDefaultLocale(locale);\n return d3.timeFormat(\"%b %Y\")\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":388,"value":"selectMonat = Inputs.range(\n [d3.min(Zeitraum.map(d => d.index)), d3.max(Zeitraum.map(d => d.index))], \n {\n label: \"\", \n step: 1,\n width: 596,\n value: d3.max(Zeitraum.map(d => d.index)),\n // format: d => formatDate(d3.timeMonth.offset(Zeitraum.map(d => d.index), d)),\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":125,"value":"view = width > 1000 ? \nvl.vconcat(\n vl.layer(\n mapBackground,\n legendText,\n mapFill.params(selectCountry),\n ) \n .project(\n vl.projection(\"albers\")\n .rotate([-12,0,0])\n .scale(660)\n .center([16, 48])\n .translate([420, 252])\n .parallels([48, 48]) \n )\n .width(675)\n .height(420)\n .data(dataSelected),\n vl.layer(lines, rule, ruleText, linesEU, linesColor)\n .width(675)\n .height(168)\n .data(data.filter(d => d.series == selectSeriesValue))\n .resolve({\n scale: {color: \"independent\"}\n })\n )\n .config(config)\n .render({ renderer: \"canvas\" })\n :\nvl.hconcat(\n vl.layer(\n mapBackground,\n mapFill.params(selectCountry),\n ) \n .project(\n vl.projection(\"albers\")\n .rotate([-12,0,0])\n .scale(680)\n .center([16, 48])\n .translate([370, 280])\n .parallels([48, 48]) \n )\n .width(580)\n .height(480)\n .data(dataSelected),\n )\n .config(config)\n .render({ renderer: \"canvas\" })","pinned":false,"hidden":false,"mode":"ojs"},{"id":484,"value":"facets = \nvl.hconcat(\n vl.layer(\n // vl.markGeoshape({ fill: '#e6f3ff', color: \"white\" })\n // .data(vl.sphere()),\n // vl.markGeoshape({ stroke: '#ffffff', strokeWidth: 0.75 })\n // .data(vl.graticule()),\n mapBackgroundFacet,\n mapFillFacet\n ) \n .project(\n vl.projection(\"albers\")\n .rotate([-12,0,0])\n .scale(195)\n .center([16, 48])\n .translate([95 , 76])\n .parallels([48, 48]) \n )\n .width(148)\n .height(130)\n .facet({\n field: \"series\", \n type: \"nominal\", \n title: null,\n header: { \n labelFontSize: 14, \n orient: \"top\",\n // labelAngle: 0, \n // labelAnchor: \"start\"\n },\n })\n .columns(2)\n .resolve({\n scale: {fill: \"independent\", color: \"independent\", x: \"independent\"}, \n axis: {fill: \"independent\", color: \"independent\"}, \n })\n .data(dataFacets),\n )\n .config(config)\n .render({ renderer: \"canvas\" })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1145,"value":"ruleText = vl.markText({\n size: 14,\n xOffset: -8,\n y: 160,\n align: \"right\",\n clip: true,\n})\n .encode(\n vl.x().fieldT(\"date\"),\n vl.text().fieldT(\"date\").format(\"%b %Y\")\n )\n .data(dataSelected.filter((d, i) => i == 1))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1030,"value":"rule = vl.markRule({\n // strokeDash: [5, 5],\n strokeWidth: 2,\n stroke: \"lightgray\"\n // strokeOpacity: 0.25,\n})\n .encode(\n vl.x().fieldT(\"date\")\n )\n .data(dataSelected)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1002,"value":"linesEU = vl.markLine({\n color: \"black\",\n strokeWidth: 1.25\n})\n .transform(\n vl.filter(\"datum.country == 'EU'\")\n )\n .encode(\n vl.y()\n .fieldQ(\"value\"),\n vl.x()\n .fieldT(\"date\"),\n )","pinned":false,"hidden":false,"mode":"ojs"},{"id":799,"value":"lines = vl.markLine({\n strokeWidth: 0.75\n})\n .encode(\n vl.y()\n .fieldQ(\"value\")\n .scale({\n zero: false,\n nice: false,\n })\n .axis({\n title: null,\n grid: false,\n domain: false,\n labelPadding: 10,\n zero: false,\n nice: false,\n minExtent: 40,\n }),\n vl.x()\n .fieldT(\"date\")\n .scale({\n padding: 12,\n })\n .axis({\n title: null,\n grid: false,\n domain: false,\n labelPadding: -30,\n }).axis(null),\n vl.color()\n .fieldN(\"country\")\n .scale({\n range: [\"#f0f0f0\"]\n })\n .legend(null)\n )","pinned":false,"hidden":false,"mode":"ojs"},{"id":871,"value":"linesColor = vl.markLine({\n strokeWidth: 1.5\n})\n .transform(\n vl.filter(selectCountry)\n )\n .encode(\n vl.y()\n .fieldQ(\"value\"),\n vl.x()\n .fieldT(\"date\"),\n vl.color()\n .fieldN(\"country\")\n .scale({\n range: colorsDiscrete\n })\n .legend(null)\n )","pinned":false,"hidden":false,"mode":"ojs"},{"id":1296,"value":"selectSeriesValue = Generators.input(selectSeries)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1300,"value":"selectMonatValue = Generators.input(selectMonat)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1600,"value":"selectScaleValue = Generators.input(selectScale)","pinned":false,"hidden":false,"mode":"ojs"},{"id":878,"value":"selectCountry = vl.selectPoint(\"selectCountry\")\n .fields(\"country\")\n .on(\"click\")\n .clear(\"none\")\n .toggle(\"event\")\n .value([\"\"])","pinned":false,"hidden":false,"mode":"ojs"},{"id":888,"value":"colorsDiscrete = [\n \"#72bb6f\",\n \"#559e8f\",\n \"#6dcbf3\",\n \"#2d76b3\",\n \"#96b428\",\n \"#c3423f\",\n \"#f3d039\",\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":753,"value":"EA_EEI_diff = textData.filter(d => d.country == \"EA\" && d.series == \"EEI\")[0].diffValue","pinned":false,"hidden":false,"mode":"ojs"},{"id":750,"value":"EA_EEI_aktuell = textData.filter(d => d.country == \"EA\" && d.series == \"EEI\")[0].value","pinned":false,"hidden":false,"mode":"ojs"},{"id":755,"value":"EU_EEI_aktuell = textData.filter(d => d.country == \"EU\" && d.series == \"EEI\")[0].value","pinned":false,"hidden":false,"mode":"ojs"},{"id":757,"value":"EU_EEI_diff = textData.filter(d => d.country == \"EU\" && d.series == \"EEI\")[0].diffValue","pinned":false,"hidden":false,"mode":"ojs"},{"id":739,"value":"EA_ESI_aktuell = textData.filter(d => d.country == \"EA\" && d.series == \"ESI\")[0].value","pinned":false,"hidden":false,"mode":"ojs"},{"id":733,"value":"EA_ESI_diff = textData.filter(d => d.country == \"EA\" && d.series == \"ESI\")[0].diffValue","pinned":false,"hidden":false,"mode":"ojs"},{"id":730,"value":"EU_ESI_aktuell = textData.filter(d => d.country == \"EU\" && d.series == \"ESI\")[0].value","pinned":false,"hidden":false,"mode":"ojs"},{"id":721,"value":"EU_ESI_diff = textData.filter(d => d.country == \"EU\" && d.series == \"ESI\")[0].diffValue","pinned":false,"hidden":false,"mode":"ojs"},{"id":697,"value":"jahr = 1900 + textData.filter(d => d.country == \"EU\")[0].date.getYear()","pinned":false,"hidden":false,"mode":"ojs"},{"id":644,"value":"monat = monate[textData.filter(d => d.country == \"EU\")[0].date.getMonth()]","pinned":false,"hidden":false,"mode":"ojs"},{"id":647,"value":"textData = values\n .groupby([\"series\", \"country\"])\n .derive({ \n maxDate: d => op.max(d.date),\n lagValue: d => op.lag(d.value, 1),\n })\n .derive({ \n diffValue: d => op.round((d.value - d.lagValue)*10) /10,\n })\n .objects()\n .filter(d => d.maxDate == d.date)","pinned":false,"hidden":false,"mode":"ojs"},{"id":390,"value":"Zeitraum = values.select(\"date\").dedupe(\"date\").derive({ index: op.row_number() }).objects()","pinned":false,"hidden":false,"mode":"ojs"},{"id":489,"value":"dataFacets = values\n .join_left(countries, \"country\")\n .join_left(geoDataFacet, ['country', 'id'])\n // .groupby([\"series\"])\n // .derive({\n // maxSeries: d => op.max(d.value),\n // minSeries: d => op.min(d.value),\n // })\n .objects()\n .filter(d => d.series != selectSeriesValue && d.series != \"SERV73\")\n .filter(d => d.date.toString() == Zeitraum[selectMonatValue - 1].date.toString())","pinned":false,"hidden":false,"mode":"ojs"},{"id":193,"value":"dataSelected = values\n .join_left(countries, \"country\")\n .join_left(geoData, ['country', 'id'])\n .objects()\n .filter(d => toggle == false ? d.series == selectSeriesValue : d.series == \"SERV73\")\n .filter(d => d.date.toString() == Zeitraum[selectMonatValue - 1].date.toString())","pinned":false,"hidden":false,"mode":"ojs"},{"id":33,"value":"data = values\n .join_left(countries, \"country\")\n .join_left(geoData, ['country', 'id'])\n // .groupby([\"series\"])\n // .derive({\n // maxSeries: d => op.max(d.value),\n // minSeries: d => op.min(d.value),\n // })\n .objects()\n // .filter(d => d.date > new Date(jahr-10,12))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1751,"value":"monate_en = [\n \"January\",\n \"February\",\n \"March\",\n \"April\",\n \"May\",\n \"June\",\n \"July\",\n \"August\",\n \"September\",\n \"October\",\n \"November\",\n \"December\"\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":458,"value":"monate = [\n \"Jänner\",\n \"Februar\",\n \"März\",\n \"April\",\n \"Mai\",\n \"Juni\",\n \"Juli\",\n \"August\",\n \"September\",\n \"Oktober\",\n \"November\",\n \"Dezember\"\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":372,"value":"extentMax = d3.max(values.objects().filter(d => d.series == selectSeriesValue).map(d => d.value)) // .filter(d => d.series == selectSeriesValue)","pinned":false,"hidden":false,"mode":"ojs"},{"id":367,"value":"extentMin = d3.min(values.objects().filter(d => d.series == selectSeriesValue).map(d => d.value)) // .filter(d => d.series == selectSeriesValue)","pinned":false,"hidden":false,"mode":"ojs"},{"id":534,"value":"mapBackgroundFacet = vl.markGeoshape({\n fill: \"#f0f0f0\" // \"white\"\n})\n .data(geoDataFacet)","pinned":false,"hidden":false,"mode":"ojs"},{"id":529,"value":"mapFillFacet = vl.markGeoshape({\n stroke: \"black\",\n strokeWidth: 0.33\n})\n .encode(\n vl.fill()\n .fieldQ(\"value\")\n .legend({\n orient: \"bottom\",\n title: null,\n format: ',.0f', \n })\n .legend(null)\n .scale({\n type: \"quantile\",\n range: colors,\n }),\n )","pinned":false,"hidden":false,"mode":"ojs"},{"id":1477,"value":"legendText = vl.markText({\n x: width > 1000 ? 625 - 17 : 500,\n dy: 30,\n clip: true,\n size: 14,\n align: \"right\",\n})\n.data([\n {offset: 0, label: \"\"},\n {offset: 57, label: \"unterdurchschnittlich\"},\n {offset: 100, label: \"überdurchschnittlich\"}\n])\n.encode(\n vl.yOffset({axis: null}).fieldQ(\"offset\"),\n vl.text().fieldN(\"label\")\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":121,"value":"mapFill = vl.markGeoshape({\n stroke: \"black\",\n})\n .encode(\n vl.fill()\n .fieldQ(\"value\")\n .legend({\n orient: \"none\",\n // labelAlign: \"left\",\n labelOffset: 8,\n legendY: 20,\n legendX: width > 1000 ? 615 : 500,\n title: null,\n format: ',.0f',\n tickCount: 5,\n })\n .scale({\n type: selectScaleValue == \"Quantile (aktuell)\" ? \"quantile\" : \"linear\",\n range: colors,\n domain: selectScaleValue == \"Gesamtzeitraum\" ? [\n extentMin, \n extentMax\n ] : null,\n }),\n vl.strokeWidth()\n .if(selectCountry, 1.25)\n .value(0.5),\n vl.tooltip([\n {field: \"value\", type: \"quantitative\", title: dataSelected[0].series},\n {field: \"date\", type: \"temporal\", title: \"Monat\", format: \"%b %Y\"},\n ]),\n )","pinned":false,"hidden":false,"mode":"ojs"},{"id":71,"value":"mapBackground = vl.markGeoshape({\n fill: \"#f0f0f0\" // \"white\"\n})\n .data(geoData)","pinned":false,"hidden":false,"mode":"ojs"},{"id":54,"value":"geojson = topojson.feature(topoRaw, \"CNTR_RG_20M_2020_4326\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":200,"value":"seriesNames = [\n \"ESI\",\n \"EEI\",\n \"SERV\",\n \"BUIL\",\n \"RETA\",\n \"CONS\",\n \"INDU\",\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":536,"value":"geoDataFacet = aq.from(geo.simplify(geojson, { k: 0.125 }).features)","pinned":false,"hidden":false,"mode":"ojs"},{"id":66,"value":"geoData = aq.from(geo.simplify(geojson, { k: 0.4 }).features)","pinned":false,"hidden":false,"mode":"ojs"},{"id":51,"value":"topoRaw = d3.json(\"https://raw.githubusercontent.com/WIFOat/fg_data/main/CNTR_RG_20M_2020_4326.json\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":31,"value":"countries = aq.loadCSV(\"https://raw.githubusercontent.com/WIFOat/fg_data/main/data_esi_countries.csv\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":20,"value":"values = aq.loadCSV(\"https://raw.githubusercontent.com/WIFOat/fg_data/main/data_esi_values.csv\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"import {vl} from \"@vega/vega-lite-api-v5\" ","pinned":false,"hidden":false,"mode":"ojs"},{"id":9,"value":"import { aq, op } from '@uwdata/arquero'","pinned":false,"hidden":false,"mode":"ojs"},{"id":277,"value":"colors = [\"#2d76b3\", \"#559bd5\", \"#99c4e6\",\"#bbd7ee\", \"#ddebf7\", \"#e3f1e2\", \"#c7e3c6\", \"#abd6a9\", \"#72bb6f\", \"#4b9847\"]","pinned":false,"hidden":false,"mode":"ojs"},{"id":18,"value":"geo = require(\"geotoolbox@2\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":15,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":12,"value":"$33","pinned":false,"hidden":false,"mode":"html"}],"files":"$W34","stdlib":"1","titling":"auto"}