Vorlage:Graph:ToteNachAutorInnen: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Void (Diskussion | Beiträge) (AutorIn/AutorInnen-Feld eingebaut) |
Void (Diskussion | Beiträge) K (Datumskonvertierung korrigiert) |
||
(6 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
Zeile 12: | Zeile 12: | ||
{ | { | ||
"name": "sub", | "name": "sub", | ||
− | "values": | + | "values": {{Data:Folgen}}, |
− | "transform": [{ | + | "transform": [ |
+ | { | ||
"type": "formula", | "type": "formula", | ||
− | "field": " | + | "field": "Datum", |
− | "expr": " | + | "expr": "datetime(substring(datum.Datum,6,10), substring(datum.Datum,3,5)-1, substring(datum.Datum,0,2))" |
− | }] | + | }, |
+ | { | ||
+ | "type": "aggregate", | ||
+ | "summarize": [{ | ||
+ | "field": "Datum", | ||
+ | "ops": ["max"], | ||
+ | "as": ["Stand"] | ||
+ | }] | ||
+ | } | ||
+ | ] | ||
},{ | },{ | ||
"name": "table", | "name": "table", | ||
"values": {{Data:Folgen}}, | "values": {{Data:Folgen}}, | ||
− | "transform": [{ | + | "transform": [ |
+ | { | ||
"type": "formula", | "type": "formula", | ||
"field": "AutorInnen", | "field": "AutorInnen", | ||
− | "expr": "datum.AutorInnen ? datum.AutorInnen : [datum.AutorIn | + | "expr": "datum.AutorInnen ? datum.AutorInnen : [datum.AutorIn]" |
− | },{ | + | }, |
+ | { | ||
"type": "fold", | "type": "fold", | ||
− | "fields": ["AutorInnen[0]", "AutorInnen[1]", "AutorInnen[2]", "AutorInnen[3]", "AutorInnen[4]"] | + | "fields": ["AutorInnen[0]", "AutorInnen[1]", "AutorInnen[2]", "AutorInnen[3]", "AutorInnen[4]", "AutorInnen[5]", "AutorInnen[6]", "AutorInnen[7]", "AutorInnen[8]", "AutorInnen[9]"] |
− | },{ | + | }, |
+ | { | ||
"type": "filter", | "type": "filter", | ||
"test": "datum.value" | "test": "datum.value" | ||
− | },{ | + | }, |
+ | { | ||
+ | "type": "formula", | ||
+ | "field": "AutorIn", | ||
+ | "expr": "datum.value" | ||
+ | }, | ||
+ | { | ||
+ | "type": "fold", | ||
+ | "fields": ["KandidatInnen[0]", "KandidatInnen[1]", "KandidatInnen[2]", "KandidatInnen[3]", "KandidatInnen[4]", "KandidatInnen[5]", "KandidatInnen[6]", "KandidatInnen[7]", "KandidatInnen[8]", "KandidatInnen[9]"] | ||
+ | }, | ||
+ | { | ||
+ | "type": "filter", | ||
+ | "test": "datum.value" | ||
+ | }, | ||
+ | { | ||
+ | "type": "formula", | ||
+ | "field": "KandidatInGestorben", | ||
+ | "expr": "datum.value.Gestorben" | ||
+ | }, | ||
+ | { | ||
"type": "aggregate", | "type": "aggregate", | ||
− | "groupby": [" | + | "groupby": ["AutorIn"], |
"summarize": [{ | "summarize": [{ | ||
"field": "KandidatInGestorben", | "field": "KandidatInGestorben", | ||
Zeile 39: | Zeile 71: | ||
"as": ["Anzahl"] | "as": ["Anzahl"] | ||
}] | }] | ||
− | },{ | + | }, |
+ | { | ||
"type": "filter", | "type": "filter", | ||
"test": "datum.Anzahl > 0" | "test": "datum.Anzahl > 0" | ||
}] | }] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
} | } | ||
], | ], | ||
Zeile 60: | Zeile 83: | ||
"type": "ordinal", | "type": "ordinal", | ||
"range": "width", | "range": "width", | ||
− | "domain": {"data": "table", "field": " | + | "domain": {"data": "table", "field": "AutorIn"} |
}, | }, | ||
{ | { | ||
Zeile 73: | Zeile 96: | ||
"type": "ordinal", | "type": "ordinal", | ||
"range": "width", | "range": "width", | ||
− | "domain": {"data": "sub", "field": " | + | "domain": {"data": "sub", "field": "Stand"} |
} | } | ||
], | ], | ||
Zeile 101: | Zeile 124: | ||
"properties": { | "properties": { | ||
"labels": { | "labels": { | ||
− | "text": {"template": "#puertoStatistiko \u007b{datum.data}\u007d"}, | + | "text": {"template": "#puertoStatistiko \u007b{datum.data{{!}}time:'%Y'}\u007d"}, |
"fontSize": {"value": {{{fontSize|14}}} }, | "fontSize": {"value": {{{fontSize|14}}} }, | ||
+ | "dx": {"value": {{{width|600}}}, "mult": -0.4}, | ||
"dy": {"value": {{{fontSize|14}}}, "mult": 2} | "dy": {"value": {{{fontSize|14}}}, "mult": 2} | ||
+ | }, | ||
+ | "axis": { | ||
+ | "strokeOpacity": {"value": 0} | ||
+ | } | ||
+ | } | ||
+ | }, | ||
+ | { | ||
+ | "type": "x", | ||
+ | "scale": "sub", | ||
+ | "tickSize": 0, | ||
+ | "properties": { | ||
+ | "labels": { | ||
+ | "text": {"template": "Stand: \u007b{datum.data{{!}}time:'%d.%m.%Y'}\u007d"}, | ||
+ | "fontSize": {"value": {{{fontSize|14}}} }, | ||
+ | "dx": {"value": {{{width|600}}}, "mult": 0.4}, | ||
+ | "dy": {"value": {{{fontSize|14}}}, "mult": 2}, | ||
}, | }, | ||
"axis": { | "axis": { | ||
Zeile 117: | Zeile 157: | ||
"properties": { | "properties": { | ||
"enter": { | "enter": { | ||
− | "x": {"scale": "x", "field": " | + | "x": {"scale": "x", "field": "AutorIn", "offset":10}, |
"width": {"scale": "x", "band": true, "offset": -20}, | "width": {"scale": "x", "band": true, "offset": -20}, | ||
"y": {"scale": "y","field": "Anzahl"}, | "y": {"scale": "y","field": "Anzahl"}, | ||
Zeile 135: | Zeile 175: | ||
{ | { | ||
"type": "text", | "type": "text", | ||
+ | "from": {"data": "table"}, | ||
"properties": { | "properties": { | ||
"enter": { | "enter": { | ||
"align": {"value": "center"}, | "align": {"value": "center"}, | ||
− | "fill": {"value": "#333" | + | "fill": {"value": "#333"}, |
− | + | "x": {"scale": "x", "field": "AutorIn"}, | |
− | |||
− | "x": {"scale": "x", " | ||
"dx": {"scale": "x", "band": true, "mult": 0.5}, | "dx": {"scale": "x", "band": true, "mult": 0.5}, | ||
− | "y": {"scale": "y", " | + | "y": {"scale": "y", "field": "Anzahl", "offset": -5}, |
− | "text": {" | + | "text": {"field": "Anzahl"}, |
"fontSize": {"value": {{{fontSize|14}}} }, | "fontSize": {"value": {{{fontSize|14}}} }, | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
} | } | ||
} | } |
Aktuelle Version vom 15. Oktober 2017, 14:50 Uhr
Die Statistik über die Anzahl der verstorbenen KandidatInnen nach AutorInnen. Die zugrunde liegenden Daten können in der Daten-Vorlage angepasst werden