Courses/EIMI 25WS/Queries - Revision history

Leonie: /* Total completions */ update query (styling)

2025-11-17T10:43:55Z

Total completions: update query (styling)

← Older revision		Revision as of 10:43, 17 November 2025
Line 16:		Line 16:
	WHERE {		WHERE {
	# color items according to their number of completions		# color items according to their number of completions

	{ wd:Q2113 wdt:P14/wdt:P14 ?topic.		{ wd:Q2113 wdt:P14/wdt:P14 ?topic.
	OPTIONAL {		OPTIONAL {
Line 38:		Line 37:

	# Styling		# Styling
	bind (if(?completions > 50, "60BB3F",		bind (if(?completions > 40, "55A630", # "60BB3F",
	if(?completions > 35, "81D064",		if(?completions > 30, "80BD34", # "81D064",
	if(?completions > 20, "9FE586", ~~# green~~		if(?completions > 20, "AAD338", # "9FE586",
	if(?completions > 10 , "B7ECA5",		if(?completions > 10, "D5E93C", # "B7ECA5",
	if(?completions > 5 , "CFF2C3",		if(?completions > 5 , "FFFF3F", # "CFF2C3",
	if(?completions > 2 , "E7F9E1",		if(?completions > 0 , "FFFFC2", # "E7F9E1",
	"FFFFFF" )))))) as ?rgb1).		"FFFFFF" )))))) as ?rgb1).

Leonie: /* Info on Students */ add query and description

2025-11-14T09:45:23Z

Info on Students: add query and description

@@ Line 46: / Line 46: @@
         "FFFFFF" )))))) as ?rgb1).
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
+}
 }}

Leonie: Create page and add inital query

2025-11-14T09:39:37Z

Create page and add inital query

New page

== Total completions ==

Query gets the count of total '''number of completions for a node''' by students that participate in EIMI 25WS and show that counts using colors.

<small>When commenting out the variable <i>?completions</i> the sizing of the nodes is removed, but also the tooltips that show the number of completions of a node on hover</small>

{{SPARQL2|query=
#defaultView:Graph
PREFIX wd: <https://graphit.ur.de/entity/>
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
SELECT distinct
?topic ?topicLabel ?rgb1
?completions # for sizing and value tooltip on hover
?dependency ?dependencyLabel
WHERE {
# color items according to their number of completions

{ wd:Q2113 wdt:P14/wdt:P14 ?topic.
OPTIONAL {
?topic wdt:P1 ?dependency
BIND (IF(EXISTS{?user wdt:P12 ?dependency}, "008F0E", "ffffff") as ?rgb2)
}
} UNION {
# get all dependencies not directly included ( for sizing they need to be in the same column as ?topic ()
wd:Q2113 wdt:P14/wdt:P14 ?item.
?item wdt:P1 ?topic.
FILTER NOT EXISTS { wd:Q2113 wdt:P14/wdt:P14 ?topic. }
}

OPTIONAL {
SELECT ?topic ?topicLabel (COUNT(DISTINCT ?student) AS ?completions) WHERE {
?student wdt:P25 wd:Q2113.
?student wdt:P12 ?topic.
} GROUP BY ?topic ?topicLabel
}
BIND(IF(!BOUND(?completions), 0, ?completions) as ?completions).

# Styling
bind (if(?completions > 50, "60BB3F",
if(?completions > 35, "81D064",
if(?completions > 20, "9FE586", # green
if(?completions > 10 , "B7ECA5",
if(?completions > 5 , "CFF2C3",
if(?completions > 2 , "E7F9E1",
"FFFFFF" )))))) as ?rgb1).

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
}}