Full identifier: https://w3id.org/np/RAy8scuivCwpbvYQn9-iJk1ymUBC8WaUcUGHW_-Ickoe4/get-weekly-active-user-count
Assigned to 1 class:
Described in 1 nanopublication:
| Nanopublication | Part | Subject | Predicate | Object | Published By | Published On |
|---|---|---|---|---|---|---|
|
links a nanopublication to its pubinfo
http://www.nanopub.org/nschema#hasPublicationInfo
pubinfo
|
get-weekly-active-user-count
|
Get weekly active user count - Returns the number of active users per (approximate) week.
|
Tobias Kuhn
|
2025-11-06T20:46:24.620Z
|
||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-weekly-active-user-count
|
Queries
|
Tobias Kuhn
|
2025-11-06T20:46:24.620Z
|
||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-weekly-active-user-count
|
Tobias Kuhn
|
2025-11-06T20:46:24.620Z
|
|||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-weekly-active-user-count
|
Tobias Kuhn
|
2025-11-06T20:22:00.756Z
|
|||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-weekly-active-user-count
|
Get weekly active user count
|
Tobias Kuhn
|
2025-11-06T20:22:00.756Z
|
||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-weekly-active-user-count
|
Tobias Kuhn
|
2025-11-06T20:22:00.756Z
|
|||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-weekly-active-user-count
|
Returns the number of active users per (approximate) week.
|
Tobias Kuhn
|
2025-11-06T20:22:00.756Z
|
||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-weekly-active-user-count
|
Tobias Kuhn
|
2025-11-06T20:22:00.756Z
|
|||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-weekly-active-user-count
|
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix np: <http://www.nanopub.org/nschema#>
prefix npa: <http://purl.org/nanopub/admin/>
prefix npx: <http://purl.org/nanopub/x/>
prefix xsd: <http://www.w3.org/2001/XMLSchema#>
prefix dct: <http://purl.org/dc/terms/>
prefix prov: <http://www.w3.org/ns/prov#>
prefix foaf: <http://xmlns.com/foaf/0.1/>
select ?approxweek (substr(str(min(?date)), 0, 11) as ?firstday) (count(distinct ?userid) as ?usercount) where {
{ graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np dct:creator ?userid .
?np dct:created ?date .
} }
union
{
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np np:hasAssertion ?assertion .
?np np:hasProvenance ?prov .
?np dct:created ?date .
}
graph ?prov {
?assertion prov:wasAttributedTo ?userid .
}
}
filter not exists {
graph npa:graph { ?np npa:hasSubIri ?userid . }
}
bind(xsd:integer((year(?date)*365 + month(?date)*365/12 + day(?date)) / 7) as ?approxweek)
}
group by ?approxweek
order by desc(?approxweek)
|
Tobias Kuhn
|
2025-11-06T20:22:00.756Z
|
||
|
links a nanopublication to its pubinfo
http://www.nanopub.org/nschema#hasPublicationInfo
pubinfo
|
get-weekly-active-user-count
|
Tobias Kuhn
|
2025-11-06T20:22:00.756Z
|