. . . . "Returns the number of active users per week (Mon-Sun)." . . . "Get weekly active user count" . . "prefix rdfs: \nprefix np: \nprefix npa: \nprefix npx: \nprefix xsd: \nprefix dct: \nprefix prov: \nprefix foaf: \n\nselect ?week (substr(str(min(?date)), 0, 11) as ?firstday) (count(distinct ?userid) as ?usercount) where {\n { graph npa:graph {\n ?np npa:hasValidSignatureForPublicKey ?pubkey .\n ?np dct:creator ?userid .\n ?np dct:created ?date .\n } }\n union\n {\n graph npa:graph {\n ?np npa:hasValidSignatureForPublicKey ?pubkey .\n ?np np:hasAssertion ?assertion .\n ?np np:hasProvenance ?prov .\n ?np dct:created ?date .\n ?np dct:creator ?tool .\n values ?tool { }\n }\n graph ?prov {\n ?assertion prov:wasAttributedTo ?userid .\n }\n }\n filter not exists {\n graph npa:graph { ?np npa:hasSubIri ?userid . }\n }\n bind(if(month(?date) <= 2, year(?date) - 1, year(?date)) as ?y)\n bind(if(month(?date) <= 2, month(?date) + 9, month(?date) - 3) as ?m)\n bind(365*?y + xsd:integer(?y/4) - xsd:integer(?y/100) + xsd:integer(?y/400) + xsd:integer((153*?m + 2)/5) + day(?date) as ?daynum)\n bind(?daynum + 1 - xsd:integer((?daynum + 1) / 7) * 7 as ?dow)\n bind(xsd:integer((?daynum - ?dow) / 7) as ?week)\n}\ngroup by ?week\norder by desc(?week)" . . "Tobias Kuhn" . "2026-03-19T09:29:33Z"^^ . . . . . . . . . . "RSA" . "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB" . "eVoFHlaZPj7neTsofU9xTZbRy/lUQAsQ/wrNaaPdZ0oQ3filwS+ctVF+igL5uBfOyXJ5ZYdAqCzfk6qpk+fERCvKDENeTM+jJeoNy4pQSRG+X72dLh7Ouz9kEhH2UMgJObEvkuHrlXa9IHuz0NwOZy81hY3NM+6r3RcaQBSVRrQ=" . . .