Difference between revisions of "stats"
From pathCast
stats
| Line 17: | Line 17: | ||
<br><br> | <br><br> | ||
<center>{{text|Lectures ({{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName)|}}||red|}})|||6|}}</center><br> | <center>{{text|Lectures ({{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName)|}}||red|}})|||6|}}</center><br> | ||
| − | < | + | <table> |
| + | <tr> | ||
| + | <td> | ||
| + | {{#cargo_query: | ||
|tables=pathCast,subspecialty | |tables=pathCast,subspecialty | ||
|join on=pathCast.subspecialty=subspecialty.subspecialty | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
| Line 25: | Line 28: | ||
|width=600px | |width=600px | ||
|height=600px | |height=600px | ||
| − | |}}</ | + | |}} |
| + | </td> | ||
| + | <td> | ||
| + | {{#cargo_query: | ||
| + | |tables=pathCast,subspecialty | ||
| + | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
| + | |fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count | ||
| + | |group by=YEAR(pathCast.date) | ||
| + | |}} | ||
| + | </td> | ||
| + | </tr> | ||
| + | </table> | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables=pathCast,subspecialty | |tables=pathCast,subspecialty | ||
Revision as of 20:31, 8 September 2020
Goodbye!