Vorlage:Graph:ToteNachGeschlecht: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Void (Diskussion | Beiträge) (Hashtag zu Graph hinzugefügt) |
Void (Diskussion | Beiträge) (Umstellung auf mehrere KandidatInnen / Zusätzliche Kategorie: HeimkehrerInnen) |
||
Zeile 13: | Zeile 13: | ||
"name": "sub", | "name": "sub", | ||
"values": [{}], | "values": [{}], | ||
− | "transform": [{ | + | "transform": [ |
+ | { | ||
"type": "formula", | "type": "formula", | ||
"field": "Year", | "field": "Year", | ||
"expr": "year(now())" | "expr": "year(now())" | ||
}] | }] | ||
− | },{ | + | }, |
+ | { | ||
"name": "table", | "name": "table", | ||
"values": {{Data:Folgen}}, | "values": {{Data:Folgen}}, | ||
− | "transform": [{ | + | "transform": [ |
+ | { | ||
+ | "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": "formula", | ||
+ | "field": "GeschlechtKandidatIn", | ||
+ | "expr": "datum.value.Geschlecht" | ||
+ | }, | ||
+ | { | ||
+ | "type": "formula", | ||
+ | "field": "BürgerIn", | ||
+ | "expr": "datum.value.BürgerIn" | ||
+ | }, | ||
+ | { | ||
"type": "aggregate", | "type": "aggregate", | ||
− | "groupby": ["KandidatInGestorben", "GeschlechtKandidatIn"], | + | "groupby": ["KandidatInGestorben", "BürgerIn", "GeschlechtKandidatIn"], |
"summarize": [{ | "summarize": [{ | ||
"field": "*", | "field": "*", | ||
Zeile 29: | Zeile 55: | ||
"as": ["Anzahl"] | "as": ["Anzahl"] | ||
}] | }] | ||
− | },{ | + | }, |
+ | { | ||
"type": "stack", | "type": "stack", | ||
"field": "Anzahl", | "field": "Anzahl", | ||
"groupby": ["GeschlechtKandidatIn"], | "groupby": ["GeschlechtKandidatIn"], | ||
− | "sortby": [" | + | "sortby": ["BürgerIn", "KandidatInGestorben"] |
− | },{ | + | }, |
+ | { | ||
"type": "formula", | "type": "formula", | ||
"field": "Schicksal", | "field": "Schicksal", | ||
− | "expr": "datum.KandidatInGestorben? 'FriedhofsbewohnerIn' : | + | "expr": "datum.BürgerIn ? 'BürgerIn' : 'HeimkehrerIn'" |
− | }] | + | }, |
+ | { | ||
+ | "type": "formula", | ||
+ | "field": "Schicksal", | ||
+ | "expr": "datum.KandidatInGestorben ? 'FriedhofsbewohnerIn' : datum.Schicksal" | ||
+ | } | ||
+ | ] | ||
} | } | ||
], | ], | ||
Zeile 65: | Zeile 99: | ||
"type": "ordinal", | "type": "ordinal", | ||
"domain": {"data": "table", "field": "Schicksal"}, | "domain": {"data": "table", "field": "Schicksal"}, | ||
− | "range": ["#00B7EB","# | + | "range": ["#00B7EB","#FFDB00","#F70070"] |
}, | }, | ||
{ | { | ||
Zeile 71: | Zeile 105: | ||
"type": "ordinal", | "type": "ordinal", | ||
"domain": {"data": "table", "field": "Schicksal"}, | "domain": {"data": "table", "field": "Schicksal"}, | ||
− | "range": ["# | + | "range": ["#27CDFC","#FFE020","#FE2085"] |
} | } | ||
], | ], |
Version vom 4. Oktober 2017, 12:37 Uhr
Die Statistik über die Anzahl Toter/Überlebender nach Geschlecht. Die zugrunde liegenden Daten können in der Daten-Vorlage angepasst werden