Template:Graph:Lines/sandbox

This is the template sandbox page for Template:Graph:Lines (diff).
See also the companion subpage for test cases.

Template documentation

Warning:

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.
To avoid unnecessary page regeneration and server load, changes should be tested on the page's sandbox.

Uses Lua:

Module:String

TNT

This template uses Module:TNT for localisation:

I18n/Template:Graphs.tab

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}
}}

See source Wikidata query and sources.

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
}}

See source Wikidata query and sources.

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.

Template parameters
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. Default tab	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). Default year	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. Default linear	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 Default %b %y (for dates)	String	optional
Y axis format	`yAxisFormat`	Changes the formatting of the Y axis labels Default ,d (for numbers)	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. Default 7	Number	optional
Y axis ticks	`yTicks, yAxisTicks`	How many ticks to show on Y axis. Auto '-' by default. 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) Default fit	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. Default category10	String	optional
Line width	`linewidth`	Line width for line charts or distance between the pie segments for pie charts. Default 2.5	Number	optional
Debug	`debug`	Debug output: if set, will show graph as raw JSON.	String	optional

Edit parameter translations

<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": 5,
  "$schema": "https://vega.github.io/schema/vega/v5.json",
  "width": 400,
  "height": 300,
"padding": "strict",
  "signals": [{"name": "rightwidth", "update": "width + padding.right", "value":"400" }],
  "data": [{
    "name": "chart",
    "url": "https://commons.wikimedia.org/w/api.php?action=jsondata&formatversion=2&title=%7B%7B%7Btable%7D%7D%7D&format=json&origin=*",
    "format": {"type": "json"
      , "property": "data"
      
    },
    "transform": [


      // Convert xField parameter into a field "_xfield"
      {"type": "formula", "as": "_xfield", "expr":
"datetime(datum.year, 0, 1)"
      },
      {"type": "collect", "sort": {"field": ["_xfield"]} }

, {"type": "formula", "as": "_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",
      "range": {"scheme": "category10"}, 
      "domain": {"data": "chart", "field": "key"}
    },

  ],

  "axes": [
    {
      "scale": "x", "orient": "bottom", "tickSize": 0,
      "tickCount": 7,
      
      
      
      "encode": { 
        "update": { "labels": { 
          
          
        } } 
       }
    },
    {
      "scale": "y", "orient": "left", "tickSize": 0,
      
      
      
      
      "encode": { 
        "labels": { 
          
          
        } 
       }
    }
  ],

  "marks": [
    // Group data by the group parameter or "key", and draw lines, one line per group
    {
      "type": "group",
      "from": {
        "facet": {
          "name": ["key"],
          "data": "chart",
          "groupby": ["key"]
        }
      },
      "marks": [
        {
          "type": "line",
          "from": {"data": ["key"]},
          "encode": {
            "hover": {
              "stroke": {"value": "red"}
            },
            "update": {
              "stroke": {"scale": "color", "field": "key"}
            },
            "enter": {
              "y": {"scale": "y", "field": "_yfield"},
              "x": {"scale": "x", "field": "_xfield"},
              "stroke": {"scale": "color", "field": "key"},
              "interpolate": {"value": "linear"},
              "strokeWidth": {"value": 2.5}
            }
          }
        }
        
      ],
    },





  ]
}

</graph>