Difference between revisions of "stats"
From pathCast
stats
Line 88: | Line 88: | ||
|where=YEAR(pathCast.date)='2016' | |where=YEAR(pathCast.date)='2016' | ||
|group by=MONTH(pathCast.date) | |group by=MONTH(pathCast.date) | ||
+ | |}} | ||
+ | <br><br> | ||
+ | <center>{{text|By year: 2016 ({{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName) |where=YEAR(pathCast.date)='2016' |}}||red|}})|||6|}}</center><br> | ||
+ | {{#cargo_query: | ||
+ | |tables=pathCast,subspecialty | ||
+ | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
+ | |fields=pathCast.date,COUNT(pathCast._pageName) | ||
+ | |group by=YEAR(pathCast.date) | ||
+ | |format=pie chart | ||
|}} | |}} | ||
|Goodbye!}} | |Goodbye!}} |
Revision as of 20:13, 8 September 2020
Goodbye!