. . . . "Returns the number of active users per quarter since 2022. Two sequences of non-organic acquisition (as part of university course) are filtered out." . . . "Get quarterly active organic user count" . . "prefix rdfs: \r\nprefix np: \r\nprefix npa: \r\nprefix npx: \r\nprefix xsd: \r\nprefix dct: \r\nprefix prov: \r\nprefix foaf: \r\n\r\nselect ?quarter (count(distinct ?userid) as ?usercount) where {\r\n { graph npa:graph {\r\n ?np npa:hasValidSignatureForPublicKey ?pubkey .\r\n ?np dct:creator ?userid .\r\n ?np dct:created ?date .\r\n } }\r\n union\r\n {\r\n graph npa:graph {\r\n ?np npa:hasValidSignatureForPublicKey ?pubkey .\r\n ?np np:hasAssertion ?assertion .\r\n ?np np:hasProvenance ?prov .\r\n ?np dct:created ?date .\r\n }\r\n graph ?prov {\r\n ?assertion prov:wasAttributedTo ?userid .\r\n }\r\n }\r\n filter not exists {\r\n graph npa:graph { ?np npa:hasSubIri ?userid . }\r\n }\r\n filter(str(?date) > \"2022\")\r\n filter(str(?date) < \"2023-10-03\" || str(?date) > \"2023-10-12\")\r\n filter(str(?date) < \"2024-09-27\" || str(?date) > \"2024-10-07\")\r\n bind(substr(str(?date), 0, 8) as ?month)\r\n bind(replace(?month, \"-0[1-3]$\", \"-Q1\") as ?quarter_temp1)\r\n bind(replace(?quarter_temp1, \"-0[4-6]$\", \"-Q2\") as ?quarter_temp2)\r\n bind(replace(?quarter_temp2, \"-0[7-9]$\", \"-Q3\") as ?quarter_temp3)\r\n bind(replace(?quarter_temp3, \"-1[0-9]$\", \"-Q4\") as ?quarter)\r\n}\r\ngroup by ?quarter\r\norder by desc(?quarter)" . . "Tobias Kuhn" . "2025-07-27T09:29:37.147Z"^^ . . . . . . . . . . . "RSA" . "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQD4Wj537OijfOWVtsHMznuXKISqBhtGDQZfdO6pbb4hg9EHMcUFGTLbWaPrP783PHv8HMAAPjvEkHLaOHMIknqhaIa5236lfBO3r+ljVdYBElBcLvROmwG+ZGtmPNZf7lMhI15xf5TfoaSa84AFRd5J2EXekK6PhaFQhRm1IpSYtwIDAQAB" . "N36DMG2zcI4/kOy66yC0PlwWyZKDmAFHE9ej9jo2aqrQbUWqjbzQ2rhnToq4uGOo3d7lfE+75312HYHKQmAr5opx4YmkJZ4JefPpqE/NwLYWAuaKlceUlscULy+axNOrwiRLuccRl6NvW+o0a7W500KGbajMEjSW9IjLkj9Ex68=" . . .