Template:Graph:Lines/sandbox: Difference between revisions
No edit summary |
No edit summary |
||
Line 45: | Line 45: | ||
|{{#if:{{{replaceZerosWith|}}} |
|{{#if:{{{replaceZerosWith|}}} |
||
| , {"type": "formula", "field": "_yfield", "expr": "max(datum.{{#if:{{{series|}}}|value|{{{value|value}}}}}, {{{replaceZerosWith}}})"}, |
| , {"type": "formula", "field": "_yfield", "expr": "max(datum.{{#if:{{{series|}}}|value|{{{value|value}}}}}, {{{replaceZerosWith}}})"}, |
||
| , {"type": "filter", "test": "datum. |
| , {"type": "filter", "test": "datum.{{#if:{{{series|}}}|value|{{{value|value}}}}} != 0"} |
||
}} |
}} |
||
| , {"type": "formula", "field": "_yfield", "expr": "datum.{{#if:{{{series|}}}|value|{{{value|value}}}}}"}, |
| , {"type": "formula", "field": "_yfield", "expr": "datum.{{#if:{{{series|}}}|value|{{{value|value}}}}}"}, |
Revision as of 19:00, 15 July 2020
This is the template sandbox page for Template:Graph:Lines (diff). See also the companion subpage for test cases. |
This page is shared between multiple wikis. All changes to this page will be automatically copied to all wikis listed in the left side bar. |
Uses Lua: |
TNT | This template uses Module:TNT for localisation: |
This graph's main version resides at Template:Graph:Lines . Please make or suggest all the changes there, and copy it everywhere else (until the copying is automated)
This graph draws one or more independent numeric data series as lines. The data must be stored on Commons' Data namespace or come from Wikidata Query Service.
Gender pay gap
{{Graph:Lines
| table=bls.gov/US Women's weekly earnings as a percent of men's by age, annual averages.tab
| type=year | xField=year
| series="age_16_24", "age_25_34", "age_35_44", "age_45_54"
| title=Gender pay gap in the United States
| yZero=false | xAxis=Year | yAxis=Percentage | yMax=100 | yGrid=y | width=500 | legend=Age group
| vAnnotationsValues={"text": "Fictitious event", "x": 1990}
}}
|
See or edit raw graph data.
|
Paintings per decades
{{Graph:Lines
| tabletype=query | 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)
FILTER( ?year <= year(now()))
} GROUP BY ?decade ORDER BY ?decade
| series="count" | type=year | xField=decade
|yAxisFormat=s
| yZero=false | width=550
| title=Paintings by decade
| hAnnotationsValues={"text": "Fictitious value", "y": 20000}
}}
|
Population in countries bordering Germany
Wikidata query produces three columns - year, population size, and country name. This graph shows one line per country.
{{Graph:Lines
| tabletype=query | table=
#Population of countries sharing a border with Germany
SELECT ?year ?population ?countryLabel WHERE {
{
SELECT ?country ?year (AVG(?populations) AS ?population) WHERE {
{
SELECT ?country (YEAR(?date) AS ?year) ?populations WHERE {
?country wdt:P47 wd:Q183.
?country p:P1082 ?populationStatement.
?populationStatement ps:P1082 ?populations.
?populationStatement pq:P585 ?date.
}
} FILTER( ?year >= 1900)
}
GROUP BY ?country ?year
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
| type=year | xField=year | group=countryLabel | value=population
| colorscheme=category20
| legend=- | xGrid=y | yGrid=y | yTicks=7| width=600
| colorscheme=category20
|yAxisFormat=.1s
}}
|
This graph draws one or more independent numeric data series as lines. The data must be stored on Commons' Data namespace or come from Wikidata Query Service.
Parameter | Description | Type | Status | |
---|---|---|---|---|
Table type | tabletype | Specifies the type of the table data. "tab" (default) uses data namespace on commons, without the data: prefix. "query" sends request to wikidata query service.
| String | optional |
Table | table | Data page name on Commons, without the Data: prefix. The table should contain xField column, like year or date, and one or more series columns to plot. If tabletype parameter is set to "query", this value is the query. | String | required |
X axis type | type | Type of the x axis - time (e.g. "2015-10" or "2013-03-08"), year (integer, but treated as a year), linear (numbers), ordinal (anything).
| String | suggested |
X field | xField | Id of the data column that contains values for the X axis. If type=year, xField is also "year" by default. | String | required |
Series | series | If each line is represented by a separate column of data (or if there is only one column), list of the data columns to show as lines. Must be in quotes, and listed by field IDs if coming from a .tab page: "field1", "field2", "field3". | String | optional |
Group | group | If line color depends on just one column, specify that column's ID, instead of the series parameter. | String | optional |
Value | value | If line color depends on one column, this parameter should be set to the column which has the values. | String | 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 | String | optional |
X axis starts at 0 | xAxisZero, xZero | Force to start or not to start X axis with zero. Can be either true or false. | String | optional |
Y axis zero starts at 0 | yAxisZero, yZero | Force to start or not to start Y axis with zero. Can be either true or false. | String | optional |
X axis scale clamp | xAxisClamp | Épingle sur l'échelle de l'axe X. Les courbes au delà de cette épingle seront cachées. | Boolean | optional |
Y axis scale clamp | yAxisClamp | Épingle sur l'échelle de l'axe Y. Les courbes au delà de cette épingle seront cachées. | Boolean | optional |
X axis minimum | xAxisMin, xMin | Force X axis to start from this value. | Number | optional |
X axis maximum | xAxisMax, xMax | Force X axis to end with this value. | Number | optional |
Y axis minimum | yAxisMin, yMin | Force Y axis to start from this value. | Number | optional |
Y axis maximum | yAxisMax, yMax | Force Y axis to end with this value. | Number | optional |
Y axis scale | yScale | Set Y axis scaling type - linear, log and sqrt.
| String | optional |
Replace zero values | replaceZerosWith | Replaces 0 values in Y data field. Recommended to be use alongside with yScale=log (else zeros will be filtered out). | Number | optional |
Title | title | Title of the whole graph. | String | optional |
Title horizontal alignment | titleXAlign | Horizontal alignment of title, could be one of: left, center, right | String | 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 | Number | optional |
X axis title | xAxisTitle | Title of the X axis. | String | optional |
Y axis title | yAxisTitle | Title of the Y axis. | String | optional |
X axis format | xAxisFormat | Changes the formatting of the X axis labels
| String | optional |
Y axis format | yAxisFormat | Changes the formatting of the Y axis labels
| String | optional |
X axis labels angle | xAxisAngle | Rotates the x axis labels by the specified angle. Recommended values are: -45, +45, -90, +90. | Number | optional |
Y axis labels angle | yAxisAngle | Rotates the y axis labels by the specified angle. | Number | optional |
X axis labels font size | xAxisFontSize | no description | Number | optional |
Y axis labels font size | yAxisFontSize | no description | Number | optional |
X axis grid | xGrid | Show grid lines for X axis. | Boolean | optional |
Y axis grid | yGrid | Show grid lines for Y axis. | Boolean | optional |
X axis ticks | xTicks, xAxisTicks | How many ticks to show on X axis. 7 by default. '-' value makes it automatic.
| Number | optional |
Y axis ticks | yTicks, yAxisTicks | How many ticks to show on Y axis. Auto '-' by default.
| Number | optional |
Raw vertical annotation values | vAnnotationsValues | Supply all annotation values as a list of JSON objects: {"text": "Big event", "x": 1980}, ... | String | optional |
Raw horizontal annotation values | hAnnotationsValues | Supply all horizontal annotation values as a list of JSON objects: {"text":"Big event", "y": 980}, ... | String | 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. | String | 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. | String | optional |
Vertical annotation data transforms | vAnnotationsTransforms | no description | String | optional |
Horizontal annotation data transforms | hAnnotationsTransforms | no description | String | optional |
Legend | legend | Title of the legend. "-" shows the legend without title. | String | optional |
Width | width | no description | Number | optional |
Height | height | no description | Number | optional |
Chart sizing mode | chartSizing | Chart sizing mode, could be one of: fit, pad. Use `fit` to force resulting chart canvas sizes to be exactly equal to provided width and height values. Use `pad` 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)
| String | optional |
Colors | colors | The colors of the lines, specified as a list like red, green. It has priority over colorscheme | String | optional |
Color scheme | colorscheme | The colors of the lines, specified as Vega defined rangeliteral.
| String | optional |
Line width | linewidth | Line width for line charts or distance between the pie segments for pie charts.
| Number | optional |
Debug | debug | Debug output: if set, will show graph as raw JSON. | String | optional |
<graph mode="interactive" title="">
{
//
// ATTENTION: This code is maintained at https://www.mediawiki.org/wiki/Template:Graph:Lines
// Please do not modify it anywhere else, as it may get copied and override your changes.
// Suggestions can be made at https://www.mediawiki.org/wiki/Template_talk:Graph:Lines
//
// Template translation is in https://commons.wikimedia.org/wiki/Data:Original/Template:Graphs.tab
//
"version": 2,
"width": 400,
"height": 300,
"padding": "strict",
"signals": [{"name": "rightwidth", "expr": "width + padding.right"}],
"data": [{
"name": "chart",
"url": "tabular:///{{{table}}}",
"format": {"type": "json"
, "property": "data"
},
"transform": [
// Convert xField parameter into a field "_xfield"
{"type": "formula", "field": "_xfield", "expr":
"datetime(datum.year, 0, 1)"
}
, {"type": "sort", "by": ["_xfield"]}
, {"type": "formula", "field": "_yfield", "expr": "datum.value"},
]
},
],
"scales": [
{
"name": "x",
"type": "time",
"domain": {"data": "chart", "field": "_xfield"},
"range": "width",
},
{
"name": "y",
"type": "linear",
"range": "height",
"domain": {"data": "chart", "field": "_yfield"},
},
{
"name": "color",
"type": "ordinal",
"domain": {"data": "chart", "field": "key"},
"range": "category10"
},
],
"axes": [
{"scale": "x", "type": "x", "tickSizeEnd": 0
, "ticks": 7
},
{"scale": "y", "type": "y", "tickSizeEnd": 0
}
],
"marks": [
// Group data by the group parameter or "key", and draw lines, one line per group
{
"type": "group",
"from": {
"data": "chart",
"transform": [{"type": "facet", "groupby": ["key"]}]
},
"marks": [
{
"type": "line",
"properties": {
"enter": {
"y": {"scale": "y", "field": "_yfield"},
"x": {"scale": "x", "field": "_xfield"},
"stroke": {"scale": "color", "field": "key"},
"interpolate": {"value": "monotone"},
"strokeWidth": {"value": 2.5}
}
}
}
],
}
]
}
</graph>