Vorlage:Graph:Stacked/Doku
Wikipedia.de Vorlage: Graph:Stacked/Doku
Info: Die Hauptversion dieser Vorlage befindet sich unter mw:Template:Graph:Stacked. Änderungswünsche sollten daher dort angefragt und durchgeführt und die Änderungen dann an die lokalen Kopien manuell verteilt werden.
Beispiele
[✎]| {{Graph:Stacked |
table=Bea.gov/GDP by state.tab |
xField=year | barwidth=14 |
series="TX","NY","CA" |
title=Per state GDP }} |
{{Graph:Stacked |
table=Bea.gov/GDP by state.tab |
xField=year | legend=States |
series="TX","NY","CA" |
title=Per state GDP }} |
|---|---|---|---|---|---|---|---|---|---|
|
<graph> { "version": 2, "width": 550, "height": 250,
"data": [ { "name": "series_fields_names",
"values": [ "TX","NY","CA" ],
"transform": [
{"type": "formula", "field": "orderSrc", "expr": "datum._id"},
]
},
{
"name": "chart",
"url": "tabular:///Bea.gov/GDP by state.tab", "format": {"type": "json"
, "property": "data" }, "transform": [
{"type": "formula", "field": "_xfield", "expr":
"datetime(datum.year, 0, 1)" },
{"type": "sort", "by": ["_xfield"]},
{"type": "fold", "fields": ["TX","NY","CA"]}, {"type": "lookup", "on": "series_fields_names", "onKey": "data", "keys": ["key"], "as": ["keyItem"]},
{"type": "formula", "field": "keyOrder", "expr": "datum.keyItem.orderSrc"},
] }, { "name": "labels",
"url": "tabular:///Bea.gov/GDP by state.tab",
"format": {"type": "json", "property": "fields"},
"transform": [
] },
{
"name": "stats",
"source": "chart",
"transform": [{
"type": "aggregate",
"groupby": ["_xfield"],
"summarize": [{"field": "value", "ops": ["sum"]}]
}]
}
],
"scales": [
{
"name": "x",
"type": "time",
"domain": {"data": "chart", "field": "_xfield"},
"range": "width",
},
{
"name": "y",
"type": "linear",
"range": "height",
"domain": {"data": "stats", "field": "sum_value"},
},
{
"name": "color",
"type": "ordinal",
"domain": {"data": "chart", "field": "key"},
"range":
"category10", }, { "name": "labels",
"type": "ordinal",
"domain": {"data": "labels", "field": "name"}, "range": {"data": "labels", "field": "title"},
}
],
"axes": [
{
"scale": "x", "type": "x", "tickSizeEnd": 0,
"ticks": 7,
"properties": {
"labels": {
}
},
},
{
"scale": "y", "type": "y", "tickSizeEnd": 0,
"offset": 8,
"properties": {
"labels": {
}
},
}
],
"marks": [
{
"type": "rect", "from": {
"data": "chart",
"transform": [
{"type": "stack", "groupby": ["_xfield"], "sortby": ["-keyOrder"], "field": "value"}
]
},
"properties": {
"hover": {
"fill": { "value": "red" }
},
"update": {
"fill": {"scale": "color", "field": "key"}
},
"enter": {
"x": {"scale": "x", "field": "_xfield"
,"offset":-7 }, "width": {"value": 14 }, "y": {"scale": "y", "field": "layout_start"},
"y2": {"scale": "y", "field": "layout_end"},
"fill": {"scale": "color", "field": "key"}
}
}
},
"type": "text",
"properties": {
"enter": {
"y": {"value": -15},
"x": {"signal": "width", "mult": 0.5, "offset": 30 }, "text": {"value": "Per state GDP"},
"fontWeight": {"value": "bold"},
"align": {"value": "center"},
"baseline": {"value": "bottom"},
"fill": {"value": "#000"}
}
}
}
]
} </graph> Rohdaten anzeigen oder bearbeiten.
|
<graph> { "version": 2, "width": 550, "height": 250,
"data": [ { "name": "series_fields_names",
"values": [ "TX","NY","CA" ],
"transform": [
{"type": "formula", "field": "orderSrc", "expr": "datum._id"},
]
},
{
"name": "chart",
"url": "tabular:///Bea.gov/GDP by state.tab", "format": {"type": "json"
, "property": "data" }, "transform": [
{"type": "formula", "field": "_xfield", "expr":
"datetime(datum.year, 0, 1)" },
{"type": "sort", "by": ["_xfield"]},
{"type": "fold", "fields": ["TX","NY","CA"]}, {"type": "lookup", "on": "series_fields_names", "onKey": "data", "keys": ["key"], "as": ["keyItem"]},
{"type": "formula", "field": "keyOrder", "expr": "datum.keyItem.orderSrc"},
{ "type": "impute",
"groupby": ["key"],
"orderby": ["_xfield"],
"field": "value",
"method": "value",
"value": 0
},
]
},
{ "name": "labels",
"url": "tabular:///Bea.gov/GDP by state.tab",
"format": {"type": "json", "property": "fields"},
"transform": [
] },
{
"name": "stats",
"source": "chart",
"transform": [{
"type": "aggregate",
"groupby": ["_xfield"],
"summarize": [{"field": "value", "ops": ["sum"]}]
}]
}
],
"scales": [
{
"name": "x",
"type": "time",
"domain": {"data": "chart", "field": "_xfield"},
"range": "width",
},
{
"name": "y",
"type": "linear",
"range": "height",
"domain": {"data": "stats", "field": "sum_value"},
},
{
"name": "color",
"type": "ordinal",
"domain": {"data": "chart", "field": "key"},
"range":
"category10", }, { "name": "labels",
"type": "ordinal",
"domain": {"data": "labels", "field": "name"}, "range": {"data": "labels", "field": "title"},
}
],
"legends": [{ "fill": "color", "stroke": "color", "title": "States", "properties": { "labels": { "text": {"scale": "labels", "field": "data"} } } }],
"axes": [
{
"scale": "x", "type": "x", "tickSizeEnd": 0,
"ticks": 7,
"properties": {
"labels": {
}
},
},
{
"scale": "y", "type": "y", "tickSizeEnd": 0,
"properties": {
"labels": {
}
},
}
],
"marks": [
{
"type": "group", "from": {
"data": "chart",
"transform": [
{"type": "stack", "groupby": ["_xfield"], "sortby": ["-keyOrder"], "field": "value"},
{"type": "facet", "groupby": ["key"]}
]
},
"marks": [
{
"type": "area",
"properties": {
"hover": {
"fill": {"value": "red"}
},
"update": {
"fill": {"scale": "color", "field": "key"}
},
"enter": {
"x": {"scale": "x", "field": "_xfield"},
"y": {"scale": "y", "field": "layout_start"},
"y2": {"scale": "y", "field": "layout_end"},
"fill": {"scale": "color", "field": "key"},
"interpolate": {"value": "monotone"}
}
}
}
],
},
"type": "text",
"properties": {
"enter": {
"y": {"value": -15},
"x": {"signal": "width", "mult": 0.5, "offset": 30 }, "text": {"value": "Per state GDP"},
"fontWeight": {"value": "bold"},
"align": {"value": "center"},
"baseline": {"value": "bottom"},
"fill": {"value": "#000"}
}
}
}
]
} </graph> Rohdaten anzeigen oder bearbeiten.
| ||||||||
| {{Graph:Stacked |
table=SELECT ?decade (COUNT(?decade) AS ?count) WHERE {
?item wdt:P31 wd:Q3305213 .
?item wdt:P571 ?inception .
BIND( year(?inception) as ?year ).
BIND( ROUND(?year/10)*10 as ?decade ) .
FILTER( ?year > 1400)
} GROUP BY ?decade ORDER BY ?decade
|
type=year | xField=decade |
title=Paintings by decade }} |
{{Graph:Stacked |
table=SELECT ?year (COUNT(?_genre) AS ?count ) (SAMPLE(?_genreLabel) AS ?label ) WHERE {
?item wdt:P31 wd:Q11424.
?item wdt:P577 ?_publication_date.
?item wdt:P136 ?_genre.
?_genre rdfs:label ?_genreLabel.
BIND(str(YEAR(?_publication_date)) AS ?year)
FILTER((LANG(?_genreLabel)) = "en")
FILTER (?_publication_date >= "2000-00-00T00:00:00Z"^^xsd:dateTime)
}
GROUP BY ?_genreLabel ?year
HAVING (?count > 30)
|
xField=year | group=label | value=count | legend=- |
title=Number of films by year and genre |
yGrid=y | colors="category20" | height=460 | barwidth=16 }} | |
|
<graph> { "version": 2, "width": 550, "height": 250,
"data": [ { "name": "series_fields_names",
"values": [ "count" ],
"transform": [
{"type": "formula", "field": "orderSrc", "expr": "datum._id"},
]
},
{
"name": "chart",
"url": "wikidatasparql:///?query=SELECT%20%3Fdecade%20%28COUNT%28%3Fdecade%29%20AS%20%3Fcount%29%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP31%20wd%3AQ3305213%20.%0A%20%20%3Fitem%20wdt%3AP571%20%3Finception%20.%0A%20%20BIND%28%20year%28%3Finception%29%20as%20%3Fyear%20%29.%20%0A%20%20BIND%28%20ROUND%28%3Fyear%2F10%29%2A10%20as%20%3Fdecade%20%29%20.%0A%20%20FILTER%28%20%3Fyear%20%3E%201400%29%0A%7D%20GROUP%20BY%20%3Fdecade%20ORDER%20BY%20%3Fdecade", "format": {"type": "json"
}, "transform": [
{"type": "formula", "field": "_xfield", "expr":
"datetime(datum.decade, 0, 1)" },
{"type": "sort", "by": ["_xfield"]},
{"type": "fold", "fields": ["count"]}, {"type": "lookup", "on": "series_fields_names", "onKey": "data", "keys": ["key"], "as": ["keyItem"]},
{"type": "formula", "field": "keyOrder", "expr": "datum.keyItem.orderSrc"},
{ "type": "impute",
"groupby": ["key"],
"orderby": ["_xfield"],
"field": "value",
"method": "value",
"value": 0
},
]
},
{
"name": "stats",
"source": "chart",
"transform": [{
"type": "aggregate",
"groupby": ["_xfield"],
"summarize": [{"field": "value", "ops": ["sum"]}]
}]
}
],
"scales": [
{
"name": "x",
"type": "time",
"domain": {"data": "chart", "field": "_xfield"},
"range": "width",
},
{
"name": "y",
"type": "linear",
"range": "height",
"domain": {"data": "stats", "field": "sum_value"},
},
{
"name": "color",
"type": "ordinal",
"domain": {"data": "chart", "field": "key"},
"range":
"category10", }, { "name": "labels",
"type": "ordinal",
"domain": ["count"], "range": ["count"], } ], "axes": [
{
"scale": "x", "type": "x", "tickSizeEnd": 0,
"ticks": 7,
"properties": {
"labels": {
}
},
},
{
"scale": "y", "type": "y", "tickSizeEnd": 0,
"properties": {
"labels": {
}
},
}
],
"marks": [
{
"type": "group", "from": {
"data": "chart",
"transform": [
{"type": "stack", "groupby": ["_xfield"], "sortby": ["-keyOrder"], "field": "value"},
{"type": "facet", "groupby": ["key"]}
]
},
"marks": [
{
"type": "area",
"properties": {
"hover": {
"fill": {"value": "red"}
},
"update": {
"fill": {"scale": "color", "field": "key"}
},
"enter": {
"x": {"scale": "x", "field": "_xfield"},
"y": {"scale": "y", "field": "layout_start"},
"y2": {"scale": "y", "field": "layout_end"},
"fill": {"scale": "color", "field": "key"},
"interpolate": {"value": "monotone"}
}
}
}
],
},
"type": "text",
"properties": {
"enter": {
"y": {"value": -15},
"x": {"signal": "width", "mult": 0.5, "offset": 30 }, "text": {"value": "Paintings by decade"},
"fontWeight": {"value": "bold"},
"align": {"value": "center"},
"baseline": {"value": "bottom"},
"fill": {"value": "#000"}
}
}
}
]
} </graph> Quell-Wikidata-Abfrage anzeigen.
|
<graph> { "version": 2, "width": 550, "height": 460,
"data": [ {
"name": "chart",
"url": "wikidatasparql:///?query=SELECT%20%20%20%3Fyear%20%20%28COUNT%28%3F_genre%29%20AS%20%3Fcount%20%29%20%28SAMPLE%28%3F_genreLabel%29%20AS%20%3Flabel%20%29%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP31%20wd%3AQ11424.%0A%20%20%3Fitem%20wdt%3AP577%20%3F_publication_date.%0A%20%20%3Fitem%20wdt%3AP136%20%3F_genre.%0A%20%20%3F_genre%20rdfs%3Alabel%20%3F_genreLabel.%0A%20%20BIND%28str%28YEAR%28%3F_publication_date%29%29%20AS%20%3Fyear%29%0A%20%20FILTER%28%28LANG%28%3F_genreLabel%29%29%20%3D%20%22en%22%29%0A%20%20%0A%20FILTER%20%28%3F_publication_date%20%3E%3D%20%222000-00-00T00%3A00%3A00Z%22%5E%5Exsd%3AdateTime%29%0A%7D%0AGROUP%20BY%20%3F_genreLabel%20%3Fyear%0AHAVING%20%28%3Fcount%20%3E%2030%29", "format": {"type": "json"
}, "transform": [
{"type": "formula", "field": "_xfield", "expr":
"datetime(datum.year, 0, 1)" },
{"type": "sort", "by": ["_xfield"]},
] },
{
"name": "stats",
"source": "chart",
"transform": [{
"type": "aggregate",
"groupby": ["_xfield"],
"summarize": [{"field": "count", "ops": ["sum"]}]
}]
}
],
"scales": [
{
"name": "x",
"type": "time",
"domain": {"data": "chart", "field": "_xfield"},
"range": "width",
},
{
"name": "y",
"type": "linear",
"range": "height",
"domain": {"data": "stats", "field": "sum_count"},
},
{
"name": "color",
"type": "ordinal",
"domain": {"data": "chart", "field": "label"},
"range":
"category20", }, ], "legends": [{ "fill": "color", "stroke": "color",
}],
"axes": [
{
"scale": "x", "type": "x", "tickSizeEnd": 0,
"ticks": 7,
"grid": true,
"properties": {
"labels": {
}
},
},
{
"scale": "y", "type": "y", "tickSizeEnd": 0,
"offset": 9,
"grid": true,
"properties": {
"labels": {
}
},
}
],
"marks": [
{
"type": "rect", "from": {
"data": "chart",
"transform": [
{"type": "stack", "groupby": ["_xfield"], "sortby": ["label"], "field": "count"}
]
},
"properties": {
"hover": {
"fill": { "value": "red" }
},
"update": {
"fill": {"scale": "color", "field": "label"}
},
"enter": {
"x": {"scale": "x", "field": "_xfield"
,"offset":-8 }, "width": {"value": 16 }, "y": {"scale": "y", "field": "layout_start"},
"y2": {"scale": "y", "field": "layout_end"},
"fill": {"scale": "color", "field": "label"}
}
}
},
"type": "text",
"properties": {
"enter": {
"y": {"value": -15},
"x": {"signal": "width", "mult": 0.5, "offset": 30 }, "text": {"value": "Number of films by year and genre"},
"fontWeight": {"value": "bold"},
"align": {"value": "center"},
"baseline": {"value": "bottom"},
"fill": {"value": "#000"}
}
}
}
]
} </graph> Quell-Wikidata-Abfrage anzeigen.
|
Parameter
[✎]Diese Vorlage gibt eine oder mehrere unabhängige numerische Datenreihen als (gestapelte) Balken- oder Flächendiagramm aus. Die Daten müssen entweder aus dem Commons-Data-Namensraum oder dem Wikidata-Abfragedienst kommen.
| Parameter | Beschreibung | Typ | Status | |
|---|---|---|---|---|
| Tabellentyp | tabletype | Gibt den Typ der Tabellendaten an. "tab" (Standard) verwendet den Data-Namensraum von Commons ohne den data:-Präfix. "query" sendet eine Abfrage an den Wikidata-Abfragedienst.
| Mehrzeiliger Text | optional |
| Tabelle | table | Name der Datenseite auf Commons ohne den data:-Präfix. Die Tabelle sollte eine xField-Spalte besitzen, sowie eine oder mehrere weitere Spalten die als Datenreihen dargestellt werden. Wenn der tableType-Parameter "query" ist dann wird hier die Abfrage eingetragen. | Mehrzeiliger Text | erforderlich |
| Typ der X-Achse | type | Typ der X-Achse - time (z.B. "2015-10" oder "2013-03-08), year (Ganzzahl die als Jahr behandelt wird), linear (Zahlen), ordinal (Sonstiges)
| Mehrzeiliger Text | vorgeschlagen |
| X-Feld | xField | Id der Datenspalte die Werte der X-Achse enthält. Wenn type=year dann ist xField standardmäßig auch "year". | Mehrzeiliger Text | erforderlich |
| Datenreihen | series | Namen der als Balken- oder Flächenabschnitte darzustellenden Datenreihen. Diese müssen in Anführungszeichen gesetzt werden und durch ihre Feld-Ids wie sie auf der .tab-Seite angegeben sind referenziert werden: "field1", "field2", "field3". | Mehrzeiliger Text | optional |
| Gruppe | group | Wenn die Farbe nur von einem Balken- oder Flächenabschnitt abhängt, kann dessen Id hier angegeben werden anstelle des Datenreihen-Parameters. | Mehrzeiliger Text | optional |
| Wert | value | Wenn die Linienfarbe nur von einer Spalte abhängt, kann hier die Spalte mit den Werten angegeben werden. | Mehrzeiliger Text | optional |
| Filter | filter | Optionally filter data with an template expression parameter e.g. `filter = datum.some_dataset_field > 1900 && datum.some_dataset_field < 2000` where `some_dataset_field` means some valid field of displayed dataset | Mehrzeiliger Text | optional |
| Balkenbreite | barwidth | Wenn gesetzt wird ein Balken- statt einem Flächendiagramm ausgegeben, wobei der Wert eine Zahl sein muss, die die Breite der Balken angibt. Wenn type=ordinal kann auch der Wert 'auto' verwendet werden. | Mehrzeiliger Text | optional |
| X-Achse startet mit 0 | xZero, xAxisZero | Erzwingt, ob die X-Achse mit dem Nullwert anfängt ("true") oder nicht ("false"). | Mehrzeiliger Text | optional |
| Y-Achse startet mit 0 | yZero, yAxisZero | Erzwingt, ob die Y-Achse mit dem Nullwert anfängt ("true") oder nicht ("false"). | Mehrzeiliger Text | optional |
| X axis scale clamp | xAxisClamp | keine Beschreibung | Wahrheitswert | optional |
| Y axis scale clamp | yAxisClamp | keine Beschreibung | Wahrheitswert | optional |
| X-Achse, Minimum | xMin, xAxisMin | Erzwingt das X-Achse mit dem angegeben Wert anfängt. | Unbekannt | optional |
| X-Achse, Maximum | xMax, xAxisMax | Erzwingt das X-Achse mit dem angegeben Wert endet. | Unbekannt | optional |
| Y-Achse, Minimum | yMin, yAxisMin | Erzwingt das Y-Achse mit dem angegeben Wert anfängt. | Unbekannt | optional |
| Y-Achse, Maximum | yMax, yAxisMin | Erzwingt das Y-Achse mit dem angegeben Wert endet. | Unbekannt | optional |
| Titel | title | Titel des Diagramms | Mehrzeiliger Text | optional |
| Title horizontal alignment | titleXAlign | Horizontal alignment of title, could be one of: left, center, right | Mehrzeiliger Text | optional |
| Title horizontal offset | titleXOffset | Horizontal offset of title position, could be negative, to shift title to the left, or positive to shift title to the right | Zahlenwert | optional |
| X-Achse, Titel | xAxis, xAxisTitle | Titel der X-Achse | Mehrzeiliger Text | optional |
| Y-Achse, Titel | yAxis, yAxisTitle | Titel der Y-Achse | Mehrzeiliger Text | optional |
| X axis labels angle | xAxisAngle | Rotates the x axis labels by the specified angle. Recommended values are: -45, +45, -90, +90. | Zahlenwert | optional |
| Y axis labels angle | yAxisAngle | Rotates the y axis labels by the specified angle. | Zahlenwert | optional |
| X axis labels font size | xAxisFontSize | keine Beschreibung | Zahlenwert | optional |
| Y axis labels font size | yAxisFontSize | keine Beschreibung | Zahlenwert | optional |
| X-Achse, Raster | xGrid | Zeigt die Hilfslinien für die X-Achse. | Wahrheitswert | optional |
| Y-Achse, Raster | yGrid | Zeigt die Hilfslinien für die Y-Achse. | Wahrheitswert | optional |
| X-Achse, Markierungsanzahl | xTicks, xAxisTicks | Wie viele Markierungen sollen an der X-Achse gezeigt werden. '-' ermittelt die Anzahl automatisch. | Zahlenwert | optional |
| Y-Achse, Markierungsanzahl | yTicks, yAxisTicks | Wie viele Markierungen sollen an der Y-Achse gezeigt werden. Standardmäßig auf automatisch '-' gesetzt. | Zahlenwert | optional |
| Raw vertical annotation values | vAnnotationsValues | Supply all annotation values as a list of JSON objects: {"text": "Big event", "x": 1980}, ... | Mehrzeiliger Text | optional |
| Raw horizontal annotation values | hAnnotationsValues | Supply all horizontal annotation values as a list of JSON objects: {"text":"Big event", "y": 980}, ... | Mehrzeiliger Text | optional |
| Vertical annotation table | vAnnotationsTable | Data page name on Commons, without the Data: prefix. The table must contain "x" column, and optional "text" and "color" columns. | Mehrzeiliger Text | optional |
| Horizontal annotation table | hAnnotationsTable | Data page name on Commons, without the Data: prefix. The table must contain "y" column, and optional "text" and "color" columns. | Mehrzeiliger Text | optional |
| Vertical annotation data transforms | vAnnotationsTransforms | keine Beschreibung | Mehrzeiliger Text | optional |
| Horizontal annotation data transforms | hAnnotationsTransforms | keine Beschreibung | Mehrzeiliger Text | optional |
| Legende | legend | Titel der Legende | Mehrzeiliger Text | optional |
| Breite | width | keine Beschreibung | Zahlenwert | optional |
| Höhe | height | keine Beschreibung | Zahlenwert | optional |
| Chart sizing mode | chartSizing | Chart sizing mode, could be one of: fit, pad. Vega default mode is `pad`. Use `fit` to force resulting chart canvas sizes to be exactly equal to provided width and height values. Use `pad` (or omit this parameter at all) to define prefered plotting size with provided width and height values, and let Vega increase overall chart size to include legend and title (if any) | Mehrzeiliger Text | optional |
| Palette | colors | Die zu verwendende Farbpalette für die Balken und Flächen. Dies kann eine Liste wie `colors = [ "red", "green" ]` oder `colors = red, green` sein.
| Mehrzeiliger Text | optional |
| debug | debug | Debugausgabe: wenn gesetzt wird das erzeugte JSON ausgegeben. | Mehrzeiliger Text | optional |
Parameterübersetzungen bearbeiten
Siehe auch
[✎]- {{Graph:Lines}} für automatisch generierte Liniendiagramme