Vorlage:Graph:AnteilVerstorbeneGesamt: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Void (Diskussion | Beiträge) (Seite neu erstellt) |
Void (Diskussion | Beiträge) K (Datumskonvertierung korrigiert) |
||
| (5 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
| − | <noinclude>Die Statistik über den Anteil an überlebenden KandidatInnen über sämtliche Folgen. Die zugrunde liegenden Daten können in der [[Vorlage:Data:Folgen|Daten-Vorlage]] angepasst werden | + | <noinclude>Die Statistik über den Anteil an überlebenden KandidatInnen über sämtliche Folgen. Die zugrunde liegenden Daten können in der [[Vorlage:Data:Folgen|Daten-Vorlage]] angepasst werden. |
== Vorschau ==</noinclude> | == Vorschau ==</noinclude> | ||
| Zeile 8: | Zeile 8: | ||
"width": {{{width|600}}}, | "width": {{{width|600}}}, | ||
"height": {{{height|300}}}, | "height": {{{height|300}}}, | ||
| − | "padding": {"top": 10,"left": 80,"bottom": | + | "padding": {"top": 10,"left": 80,"bottom": 70,"right": 80}, |
"data": [ | "data": [ | ||
{ | { | ||
| + | "name": "sub", | ||
| + | "values": {{Data:Folgen}}, | ||
| + | "transform": [ | ||
| + | { | ||
| + | "type": "formula", | ||
| + | "field": "Datum", | ||
| + | "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|{{Data:Folgen}} }}}, | "values": {{{data|{{Data:Folgen}} }}}, | ||
| Zeile 16: | Zeile 34: | ||
{ | { | ||
"type": "formula", | "type": "formula", | ||
| − | "field": " | + | "field": "Eins", |
| − | + | "expr": "1"}, | |
| − | |||
| − | |||
{ | { | ||
"type": "stack", | "type": "stack", | ||
| − | "field": " | + | "field": "Eins", |
"sortby": ["Staffel", "Folge"] | "sortby": ["Staffel", "Folge"] | ||
}, | }, | ||
{ | { | ||
"type": "formula", | "type": "formula", | ||
| − | "field": " | + | "field": "Folgen", |
"expr": "datum.layout_end" | "expr": "datum.layout_end" | ||
| + | }, | ||
| + | { | ||
| + | "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" | ||
}, | }, | ||
{ | { | ||
| Zeile 38: | Zeile 62: | ||
"type": "formula", | "type": "formula", | ||
"field": "Anzahl", | "field": "Anzahl", | ||
| + | "expr": "datum.layout_end" | ||
| + | }, | ||
| + | { | ||
| + | "type": "formula", | ||
| + | "field": "VerstorbenNumerisch", | ||
| + | "expr": "datum.value.Gestorben ? 1 : 0" | ||
| + | }, | ||
| + | { | ||
| + | "type": "aggregate", | ||
| + | "groupby": ["Staffel", "Folge", "Folgen"], | ||
| + | "summarize": [ | ||
| + | { | ||
| + | "field": "VerstorbenNumerisch", | ||
| + | "ops": ["sum"], | ||
| + | "as": ["sum_VerstorbenNumerisch"] | ||
| + | }, | ||
| + | { | ||
| + | "field": "Anzahl", | ||
| + | "ops": ["max"], | ||
| + | "as": ["max_Anzahl"] | ||
| + | } | ||
| + | ] | ||
| + | }, | ||
| + | { | ||
| + | "type": "stack", | ||
| + | "field": "sum_VerstorbenNumerisch", | ||
| + | "sortby": ["Staffel", "Folge"] | ||
| + | }, | ||
| + | { | ||
| + | "type": "formula", | ||
| + | "field": "Verstorbene", | ||
"expr": "datum.layout_end" | "expr": "datum.layout_end" | ||
}, | }, | ||
| Zeile 43: | Zeile 98: | ||
"type": "formula", | "type": "formula", | ||
"field": "AnteilVerstorbene", | "field": "AnteilVerstorbene", | ||
| − | "expr": "datum.Verstorbene / datum. | + | "expr": "datum.Verstorbene / datum.max_Anzahl" |
} | } | ||
] | ] | ||
| Zeile 53: | Zeile 108: | ||
"type": "linear", | "type": "linear", | ||
"range": "width", | "range": "width", | ||
| − | "domain": {"data": "table","field": " | + | "domain": {"data": "table","field": "Folgen"} |
}, | }, | ||
{ | { | ||
| Zeile 61: | Zeile 116: | ||
"domain": {"data": "table","field": "AnteilVerstorbene"}, | "domain": {"data": "table","field": "AnteilVerstorbene"}, | ||
"nice": true | "nice": true | ||
| + | }, | ||
| + | { | ||
| + | "name": "sub", | ||
| + | "type": "ordinal", | ||
| + | "range": "width", | ||
| + | "domain": {"data": "sub", "field": "Stand"} | ||
}, | }, | ||
{ | { | ||
| Zeile 93: | Zeile 154: | ||
}, | }, | ||
"title": {"fontSize": {"value": {{{fontSize|14}}} } } | "title": {"fontSize": {"value": {{{fontSize|14}}} } } | ||
| + | } | ||
| + | }, | ||
| + | { | ||
| + | "type": "x", | ||
| + | "scale": "sub", | ||
| + | "tickSize": 0, | ||
| + | "properties": { | ||
| + | "labels": { | ||
| + | "text": {"template": "#puertoStatistiko \u007b{datum.data{{!}}time:'%Y'}\u007d"}, | ||
| + | "fontSize": {"value": {{{fontSize|14}}} }, | ||
| + | "dx": {"value": {{{width|600}}}, "mult": -0.4}, | ||
| + | "dy": {"value": {{{fontSize|14}}}, "mult": 3} | ||
| + | }, | ||
| + | "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": 3}, | ||
| + | }, | ||
| + | "axis": { | ||
| + | "strokeOpacity": {"value": 0} | ||
| + | } | ||
} | } | ||
} | } | ||
| Zeile 110: | Zeile 203: | ||
"properties": { | "properties": { | ||
"update": { | "update": { | ||
| − | "x": {"scale": "x","field": " | + | "x": {"scale": "x","field": "Folgen"}, |
"y": {"scale": "y","field": "AnteilVerstorbene"}, | "y": {"scale": "y","field": "AnteilVerstorbene"}, | ||
"stroke": {"scale": "color","field": "Staffel"}, | "stroke": {"scale": "color","field": "Staffel"}, | ||
| Zeile 122: | Zeile 215: | ||
"properties": { | "properties": { | ||
"enter": { | "enter": { | ||
| − | "x": {"scale": "x","field": " | + | "x": {"scale": "x","field": "Folgen"}, |
"y": {"scale": "y","field": "AnteilVerstorbene"}, | "y": {"scale": "y","field": "AnteilVerstorbene"}, | ||
"size": {"value": 50} | "size": {"value": 50} | ||
Aktuelle Version vom 15. Oktober 2017, 14:48 Uhr
Die Statistik über den Anteil an überlebenden KandidatInnen über sämtliche Folgen. Die zugrunde liegenden Daten können in der Daten-Vorlage angepasst werden.