Mall:Graph:Lines/dok - Versionshistorik

Jan Karlsson den 6 juni 2021 kl. 18.14

2021-06-06T18:14:48Z

← Äldre version		Versionen från 6 juni 2021 kl. 18.14
Rad 68:		Rad 68:
	SELECT ?year ?_population ?countryLabel WHERE {		SELECT ?year ?_population ?countryLabel WHERE {
	{		{
	SELECT ?country ?year (AVG(?~~population~~) AS ?~~_population~~) WHERE {		SELECT ?country ?year (AVG(?populations) AS ?population) WHERE {
	{		{
	SELECT ?country (YEAR(?date) AS ?year) ?~~population~~ WHERE {		SELECT ?country (YEAR(?date) AS ?year) ?populations WHERE {
	?country wdt:P47 wd:Q183.		?country wdt:P47 wd:Q183.
	?country p:P1082 ?populationStatement.		?country p:P1082 ?populationStatement.
	?populationStatement ps:P1082 ?~~population~~.		?populationStatement ps:P1082 ?populations.
	?populationStatement pq:P585 ?date.		?populationStatement pq:P585 ?date.
	}		}
Rad 80:		Rad 80:
	GROUP BY ?country ?year		GROUP BY ?country ?year
	}		}
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "{{CONTENTLANGUAGE}}". }
	}		}
	\| type=year \| xField=year \| group=countryLabel \| value=population		\| type=year \| xField=year \| group=countryLabel \| value=population
Rad 94:		Rad 94:
	SELECT ?year ?_population ?countryLabel WHERE {		SELECT ?year ?_population ?countryLabel WHERE {
	{		{
	SELECT ?country ?year (AVG(?~~population~~) AS ?_population) WHERE {		SELECT ?country ?year (AVG(?populations) AS ?_population) WHERE {
	{		{
	SELECT ?country (YEAR(?date) AS ?year) ?~~population~~ WHERE {		SELECT ?country (YEAR(?date) AS ?year) ?populations WHERE {
	?country wdt:P47 wd:Q183.		?country wdt:P47 wd:Q183.
	?country p:P1082 ?populationStatement.		?country p:P1082 ?populationStatement.
	?populationStatement ps:P1082 ?~~population~~.		?populationStatement ps:P1082 ?populations.
	?populationStatement pq:P585 ?date.		?populationStatement pq:P585 ?date.
	}		}
Rad 106:		Rad 106:
	GROUP BY ?country ?year		GROUP BY ?country ?year
	}		}
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "{{CONTENTLANGUAGE}}". }
	}		}
	\| type=year \| xField=year		\| type=year \| xField=year
Rad 121:		Rad 121:
	[[Kategori:Lua-baserade mallar]]		[[Kategori:Lua-baserade mallar]]
	[[Kategori:Diagrammallar]]		[[Kategori:Diagrammallar]]
			[[Kategori:Mallar som använder tabelldata på Commons]]
	</includeonly>		</includeonly>

Jan Karlsson: 1 version importerades

2021-01-04T18:08:59Z

1 version importerades

← Äldre version	Versionen från 4 januari 2021 kl. 18.08
(Ingen skillnad)

jarnvagsdata>Ainali: lagar exempelquery

2020-11-18T18:29:14Z

lagar exempelquery

Ny sida

{{Dokumentationssida}}

{{warning|As of 4 October 2019 (and since early July 2019 at least), the graph extension no longer works when linked to a wikidata query. Until a solution is found, this template should not be used with a wikidata query in articles. See [https://phabricator.wikimedia.org/T226250 the Phabricator ticket] for more information. }}

'''This graph's main version resides at [https://www.mediawiki.org/wiki/Template:Graph:Lines 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.

{| class="wikitable"
| style="text-align: left;" | <syntaxhighlight lang="text">{{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
}}</syntaxhighlight>
| style="text-align: left;" | <syntaxhighlight lang="sparql">{{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)
} GROUP BY ?decade ORDER BY ?decade

| series="count" | type=year | xField=decade
| title=Paintings by decade

}}</syntaxhighlight>
|-
| {{{{BASEPAGENAME}}
| 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"
| yZero=false
| title=Gender pay gap in the United States
| xAxis=Year
| yAxis=Percentage
| yMax=100
| yGrid=y
| width=500
| legend=Age group
}}
| {{{{BASEPAGENAME}}
|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)
} GROUP BY ?decade ORDER BY ?decade
|series="count"
|type=year
|xField=decade
|title=Paintings by decade
}}
|-
| style="text-align: left;" | Wikidata query produces three columns - year, population size, and country name. This graph shows one line per country.
<syntaxhighlight lang="sparql">{{Graph:Lines
| tabletype=query | table=

#Population of countries sharing a border with Germany
SELECT ?year ?_population ?countryLabel WHERE {
{
SELECT ?country ?year (AVG(?population) AS ?_population) WHERE {
{
SELECT ?country (YEAR(?date) AS ?year) ?population WHERE {
?country wdt:P47 wd:Q183.
?country p:P1082 ?populationStatement.
?populationStatement ps:P1082 ?population.
?populationStatement pq:P585 ?date.
}
}
}
GROUP BY ?country ?year
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
| type=year | xField=year | group=countryLabel | value=population
| title=Population of countries bordering Germany
| legend=- | xGrid=y | yGrid=y | yTicks=7 | width=600

}}</syntaxhighlight>
|-
| {{{{BASEPAGENAME}}
| tabletype=query
| table=
#Population of countries sharing a border with Germany
SELECT ?year ?_population ?countryLabel WHERE {
{
SELECT ?country ?year (AVG(?population) AS ?_population) WHERE {
{
SELECT ?country (YEAR(?date) AS ?year) ?population WHERE {
?country wdt:P47 wd:Q183.
?country p:P1082 ?populationStatement.
?populationStatement ps:P1082 ?population.
?populationStatement pq:P585 ?date.
}
}
}
GROUP BY ?country ?year
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
| type=year | xField=year
| group=countryLabel | value=_population
| title=Population of countries bordering Germany
| legend=- | xGrid=y | yGrid=y | yTicks=7 | width=600
}}
|}

{{#invoke:TNT|doc|Graph:Lines}}

<includeonly>

[[Kategori:Lua-baserade mallar]]
[[Kategori:Diagrammallar]]
</includeonly>