get-monthly-active-user-count

Full identifier: https://w3id.org/np/RA1Tz7srP6NDcaA0-cAl4nY1rASWmcFrhgxlVtwq_DLXY#get-monthly-active-user-count

Assigned to 1 class:

Minted in Nanopublication

 Get monthly active user count grlc-query comment approve/disapprove edit as derived nanopublication create new with same template

This is the identifier for this whole nanopublication. https://w3id.org/np/RA1Tz7srP6... This nanopublication date and time when the nanopublication was created http://purl.org/dc/terms/created was created on (this is a literal) "2024-12-08T11:15:18.688Z" .
This is the identifier for this whole nanopublication. https://w3id.org/np/RA1Tz7srP6... This nanopublication links to the assertion template that was used to create this nanopublication https://w3id.org/np/o/ntemplate/wasCreatedFromTemplate was created from the assertion template https://w3id.org/np/RAYvkQOT9-... RAYvkQOT9- .
This is the identifier for this whole nanopublication. https://w3id.org/np/RA1Tz7srP6... This nanopublication links to the provenance template that was used to create this nanopublication https://w3id.org/np/o/ntemplate/wasCreatedFromProvenanceTemplate was created from the provenance template http://purl.org/np/RANwQa4ICW... RANwQa4ICW .
This is the identifier for this whole nanopublication. https://w3id.org/np/RA1Tz7srP6... This nanopublication links to the publication info template that was used to create this nanopublication https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate was created from the publication info template https://w3id.org/np/RA0J4vUn_d... RA0J4vUn_d .
This is the identifier for this whole nanopublication. https://w3id.org/np/RA1Tz7srP6... This nanopublication links to the publication info template that was used to create this nanopublication https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate was created from the publication info template https://w3id.org/np/RAukAcWHRD... RAukAcWHRD .
This is the identifier for this whole nanopublication. https://w3id.org/np/RA1Tz7srP6... This nanopublication the nanopublication consists of an introduction of the given resource http://purl.org/nanopub/x/introduces introduces This is a local identifier minted within the nanopublication. https://w3id.org/np/RA1Tz7srP6...#get-monthly-active-user-count get-monthly-active-user-count .
This is a local identifier minted within the nanopublication. https://w3id.org/np/RA1Tz7srP6...#sig sig http://purl.org/nanopub/x/hasSignatureTarget has as target This is the identifier for this whole nanopublication. https://w3id.org/np/RA1Tz7srP6... this nanopublication .
This is a local identifier minted within the nanopublication. https://w3id.org/np/RA1Tz7srP6...#sig sig http://purl.org/nanopub/x/hasAlgorithm has the algorithm (this is a literal) "RSA" .

Tobias Kuhn, 8 Dec 2024, 11:15:18 UTC

run this query

References

Nanopublication Part Subject Predicate Object Published By Published On
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

Raw

TriG(txt), JSON-LD(txt), N-Quads(txt), XML(txt)