4,315
edits
![]() |
Want to learn more about Metabase, share your ideas or get help? You're welcome to the Metabase Office Hours and chat with the Wikimedia Sverige team! Friday, August 23, 9am Swedish time (convert time zone) – join in Google Meet Friday, August 23, 4pm Swedish time (convert time zone) – join in Google Meet |
Line 61: | Line 61: | ||
==Most common programmatic areas for WMSE projects== | ==Most common programmatic areas for WMSE projects== | ||
<SPARQL tryit="1"> | <SPARQL tryit="1"> | ||
PREFIX wb: <https://metabase.wikibase.cloud/entity/> | |||
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/> | |||
#defaultView:BubbleChart | |||
SELECT ?program ?programLabel (COUNT(?item) AS ?count) | |||
WHERE | |||
{ | |||
?item wbt:P5 wb:Q2 . | |||
?item wbt:P14 wb:Q9. | |||
?item wbt:P10 ?program. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". } | |||
} | |||
GROUP BY ?program ?programLabel | |||
ORDER BY DESC(?count) | |||
</SPARQL> | </SPARQL> | ||