LinguaLibre
Difference between revisions of "Stats/Time"
< LinguaLibre:Stats
WikiLucas00 (talk | contribs) (+ Menu) |
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 |
||
(9 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
<languages/> | <languages/> | ||
− | + | {{LinguaLibre:Stats/Menu}} | |
− | {{ | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | }} | ||
<translate> | <translate> | ||
== Monthly activity == <!--T:1--> | == Monthly activity == <!--T:1--> | ||
</translate> | </translate> | ||
− | <query 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>"> | + | <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 34: | Line 18: | ||
} | } | ||
GROUP BY ?yearmonth | GROUP BY ?yearmonth | ||
− | ORDER BY ?yearmonth | + | ORDER BY DESC(?yearmonth) |
</query> | </query> | ||
<translate> | <translate> | ||
+ | |||
== The most prolific speakers for the current month == <!--T:6--> | == The most prolific speakers for the current month == <!--T:6--> | ||
</translate> | </translate> | ||
− | <query _pagination="10" locutor="<translate><!--T:7--> Item (locutor Qid)</translate>" locutorLabel="<translate><!--T:8--> | + | <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 61: | Line 46: | ||
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
</query> | </query> | ||
+ | |||
+ | [[Category:Lingua Libre:DataViz{{#translation:}}]] |