Full identifier: https://w3id.org/np/RA1Tz7srP6NDcaA0-cAl4nY1rASWmcFrhgxlVtwq_DLXY#get-monthly-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-monthly-active-user-count
|
Get monthly active user count - Returns the number of active users per month.
|
Tobias Kuhn
|
2025-09-12T15:03:23.046Z
|
||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-monthly-active-user-count
|
Queries
|
Tobias Kuhn
|
2025-09-12T15:03:23.046Z
|
||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-monthly-active-user-count
|
Tobias Kuhn
|
2025-09-12T15:03:23.046Z
|
|||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-monthly-active-user-count
|
Tobias Kuhn
|
2024-12-08T11:15:18.688Z
|
|||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-monthly-active-user-count
|
Get monthly active user count
|
Tobias Kuhn
|
2024-12-08T11:15:18.688Z
|
||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-monthly-active-user-count
|
Tobias Kuhn
|
2024-12-08T11:15:18.688Z
|
|||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-monthly-active-user-count
|
Returns the number of active users per month.
|
Tobias Kuhn
|
2024-12-08T11:15:18.688Z
|
||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-monthly-active-user-count
|
Tobias Kuhn
|
2024-12-08T11:15:18.688Z
|
|||
|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
get-monthly-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 ?month (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(substr(str(?date), 0, 8) as ?month)
}
group by ?month
order by desc(?month)
|
Tobias Kuhn
|
2024-12-08T11:15:18.688Z
|
||
|
links a nanopublication to its pubinfo
http://www.nanopub.org/nschema#hasPublicationInfo
pubinfo
|
get-monthly-active-user-count
|
Tobias Kuhn
|
2024-12-08T11:15:18.688Z
|