[Wikidata-bugs] [Maniphest] [Changed Subscribers] T191891: Track number of constraint definition snaks over time

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE added subscribers: Addshore, Lucas_Werkmeister_WMDE. Lucas_Werkmeister_WMDE added a comment.

Query:

SELECT ?type ?typeLabel ?count WHERE {
  {
    SELECT ?type (COUNT(DISTINCT ?constraint) AS ?count) WHERE {
      ?property a wikibase:Property;
                p:P2302 ?constraint.
      ?constraint ps:P2302 ?type.
    }
    GROUP BY ?type ?typeLabel
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?count)

Results

I assume to track this over time we need to run that query periodically somewhere and write the results to Graphite. @Addshore I think you set up something similar for the number of open tasks, do you know how to do this?

Minor detail: what exactly do we want to track? The most logical thing would be the constraint type item ID, but then it will be a bit tricky to look at in Grafana. But if we track the English label the results will become disconnected any time that label changes.

TASK DETAIL

https://phabricator.wikimedia.org/T191891

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Lucas_Werkmeister_WMDE
Cc: Lucas_Werkmeister_WMDE, Addshore, Aklapper, Lydia_Pintscher, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Agabi10, Wikidata-bugs, aude, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs