Graph Statistics - Revision history

Leonie: /* Simple Metrics */ update metrics

2024-02-09T10:38:56Z

Simple Metrics: update metrics

@@ Line 23: / Line 23: @@
 {{#get_web_data:url=http://query.graphit.ur.de/proxy/wdqs/bigdata/namespace/wdq/sparql?query=%23defaultView%3ATable%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fgraphit.ur.de%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fgraphit.ur.de%2Fprop%2Fdirect%2F%3E%0ASELECT%20(COUNT%20(DISTINCT%20%3Fcourse)%20as%20%3Fcourses)%0AWHERE%20%7B%0A%20%20%3Fcourse%20wdt%3AP3%20wd%3AQ170.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D&format=json
 |format=json
 |use jsonpath
@@ Line 34: / Line 40: @@
 * '''{{#external_value:resources}}''' resources
 * '''{{#external_value:students}}''' active student users
-* '''{{#external_value:courses}}''' courses
+*  '''{{#external_value:courses}}''' courses
 == ItemCount ==
 Gives a count of all items in the Wikibase-instance.

2023-12-05T11:50:34Z

Simple Metrics: added courses to inline stats

← Older revision		Revision as of 11:50, 5 December 2023
Line 20:		Line 20:
	\|use jsonpath		\|use jsonpath
	\|data=students=$.results.bindings[0].students.value,		\|data=students=$.results.bindings[0].students.value,
			}}

			{{#get_web_data:url=http://query.graphit.ur.de/proxy/wdqs/bigdata/namespace/wdq/sparql?query=%23defaultView%3ATable%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fgraphit.ur.de%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fgraphit.ur.de%2Fprop%2Fdirect%2F%3E%0ASELECT%20(COUNT%20(DISTINCT%20%3Fcourse)%20as%20%3Fcourses)%0AWHERE%20%7B%0A%20%20%3Fcourse%20wdt%3AP3%20wd%3AQ170.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D&format=json
			\|format=json
			\|use jsonpath
			\|data=courses=$.results.bindings[0].courses.value,
	}}		}}

Line 28:		Line 34:
	* '''{{#external_value:resources}}''' resources		* '''{{#external_value:resources}}''' resources
	* '''{{#external_value:students}}''' active student users		* '''{{#external_value:students}}''' active student users
			* '''{{#external_value:courses}}''' courses

	== ItemCount ==		== ItemCount ==

2023-12-05T11:38:58Z

Simple Metrics: redo as inline query

@@ Line 6: / Line 6: @@
 = Simple Metrics =
 == ItemCount ==
 Gives a count of all items in the Wikibase-instance.

2023-11-30T12:53:45Z

added: Path

@@ Line 228: / Line 228: @@
 ORDER BY DESC(?item)
 LIMIT 50 # change as needed
 }}

2023-11-29T14:34:33Z

Simple Metrics: added StudentCount

← Older revision		Revision as of 14:34, 29 November 2023
Line 50:		Line 50:
	=== Course ResourceCount ===		=== Course ResourceCount ===
	Gives back the amount of Resources used in a specific course.		Gives back the amount of Resources used in a specific course.
	Note: This query works with the "included in" dependencies.		{{Note\|text=This query works with the "included in" dependencies}}

	{{SPARQL2\|query=		{{SPARQL2\|query=
Line 65:		Line 65:
	}}		}}
	''Make inline''		''Make inline''

			=== StudentCount ===
			Gives the amount of Students using GraphIT.

			{{SPARQL2\|query=
			#defaultView:Table
			PREFIX wd: <https://graphit.ur.de/entity/>
			PREFIX wdt: <https://graphit.ur.de/prop/direct/>
			SELECT (COUNT (DISTINCT ?student) as ?students)
			WHERE {
			?student wdt:P3 wd:Q167
			SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
			}
			}}

	== SessionCount ==		== SessionCount ==

2023-11-29T14:27:48Z

Added SessionOverlap

@@ Line 214: / Line 214: @@
 ORDER BY DESC(?item)
 LIMIT 50 # change as needed
 }}

2023-11-29T12:53:09Z

Added: Session- and TopicCount

@@ Line 65: / Line 65: @@
 }}
 ''Make inline''
 = Degree of an Item =

2023-11-28T12:55:07Z

ResourceCount: added Course Resource Count

@@ Line 45: / Line 45: @@
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
+}
 }}
 ''Make inline''

2023-11-28T12:45:04Z

Simple Metrics: added ResourceCount

@@ Line 31: / Line 31: @@
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 } LIMIT 28
 }}
 ''Make inline''

2023-11-28T12:31:39Z

Degree of an Item: changed hierarchy of sections

← Older revision		Revision as of 12:31, 28 November 2023
Line 34:		Line 34:
	''Make inline''		''Make inline''

	== Degree of an Item ==		= Degree of an Item =
	Gives back the indegree and outdegree of a specific item.		Gives back the indegree and outdegree of a specific item.
	* '''InDegree''' = all dependencies (P1) going '''in''' to the item		* '''InDegree''' = all dependencies (P1) going '''in''' to the item
Line 59:		Line 59:
	''Change harcoded item to parameter''		''Change harcoded item to parameter''

	=== Highest Degrees ===		== Highest Degrees ==
	{{#widget:SPARQLquery\|code=		{{#widget:SPARQLquery\|code=
	#defaultView:ScatterChart		#defaultView:ScatterChart
Line 81:		Line 81:
	''Query currently limited to 15 items + items can overlap in the chart, for further information use the table-view'''		''Query currently limited to 15 items + items can overlap in the chart, for further information use the table-view'''

	=== Sinks ===		== Sinks ==
	Returns sinks, items with '''0 indegrees'''.		Returns sinks, items with '''0 indegrees'''.
	These items can be regarded as destinations to a path.		These items can be regarded as destinations to a path.
Line 112:		Line 112:
	}}		}}

	=== Sources ===		== Sources ==
	Returns sources, items with '''0 outdegrees'''.		Returns sources, items with '''0 outdegrees'''.
	These items can be regarded as origins to a path.		These items can be regarded as origins to a path.