4,316
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 |
(→Events) |
|||
Line 88: | Line 88: | ||
=Events= | =Events= | ||
==Most common locations for WMSE events== | ==Most common locations for WMSE events== | ||
<SPARQL tryit="1"> | |||
PREFIX wb: <https://metabase.wikibase.cloud/entity/> | |||
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/> | |||
#defaultView:BubbleChart | |||
SELECT ?location ?locationLabel (COUNT(?item) AS ?count) | |||
WHERE | |||
{ | |||
?item wbt:P5/wbt:P4* wb:Q40 . | |||
?item wbt:P27 ?location. | |||
?item wbt:P14 wb:Q9. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". } | |||
} | |||
GROUP BY ?location ?locationLabel | |||
ORDER BY DESC(?count) | |||
</SPARQL> | |||
==Number of events 2021-2022 and total number of participants== | ==Number of events 2021-2022 and total number of participants== | ||
<SPARQL tryit="1"> | <SPARQL tryit="1"> |