LinguaLibre
Difference between revisions of "Stats/Time"
< LinguaLibre:Stats
WikiLucas00 (talk | contribs) (Created page with "== Monthly activity == <query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active languages"> SELECT ?yearmonth (COUNT(DISTINCT ?record) AS ?r...") |
WikiLucas00 (talk | contribs) (Please start a community discussion before adding such a feature on a widely seen page. We could vote and define together the best technical solution to add and maintain stats graphs.) Tag: Undo |
||
| (12 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | == Monthly activity == | + | <languages/> |
| − | + | {{LinguaLibre:Stats/Menu}} | |
| − | <query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active languages"> | + | <translate> |
| + | == Monthly activity == <!--T:1--> | ||
| + | </translate> | ||
| + | <query _pagination="20" yearmonth="<translate><!--T:2--> Date</translate>" records="<translate><!--T:3--> New records</translate>" speakers="<translate><!--T:4--> Active speakers</translate>" languages="<translate><!--T:5--> Active languages</translate>"> | ||
SELECT | SELECT | ||
?yearmonth | ?yearmonth | ||
| Line 15: | Line 18: | ||
} | } | ||
GROUP BY ?yearmonth | GROUP BY ?yearmonth | ||
| − | ORDER BY ?yearmonth | + | ORDER BY DESC(?yearmonth) |
</query> | </query> | ||
| − | + | <translate> | |
| − | <query _pagination="10" locutor="Item (locutor Qid)" locutorLabel=" | + | == The most prolific speakers for the current month == <!--T:6--> |
| + | </translate> | ||
| + | <query _pagination="10" locutor="<translate><!--T:7--> Item (locutor Qid)</translate>" locutorLabel="<translate><!--T:8--> Speakers of the Month</translate>" nb="<translate><!--T:9--> Number of records</translate>"> | ||
SELECT ?locutor ?locutorLabel ?nb WHERE { | SELECT ?locutor ?locutorLabel ?nb WHERE { | ||
{ | { | ||
| Line 41: | Line 46: | ||
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
</query> | </query> | ||
| + | |||
| + | [[Category:Lingua Libre:DataViz{{#translation:}}]] | ||
