LinguaLibre
Difference between revisions of "Stats/Time"
< LinguaLibre:Stats
(Marked this version for translation) |
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 |
||
| (10 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 17: | 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 44: | Line 46: | ||
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
</query> | </query> | ||
| + | |||
| + | [[Category:Lingua Libre:DataViz{{#translation:}}]] | ||
