Difference between revisions of "stats"
From pathCast
stats
| Line 17: | Line 17: | ||
<br><br> | <br><br> | ||
<center>{{text|Lectures|||6|}}</center><br> | <center>{{text|Lectures|||6|}}</center><br> | ||
| + | <center>{{text|By year ({{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName)|}}||red|}})|||6|}}<br> | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables=pathCast,subspecialty | |tables=pathCast,subspecialty | ||
|join on=pathCast.subspecialty=subspecialty.subspecialty | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
| − | |fields=subspecialty.hashtag,COUNT(pathCast.subspecialty) | + | |fields=CONCAT(YEAR(pathCast.date),' (',COUNT(pathCast._pageName),')'),COUNT(pathCast._pageName) |
| + | |group by=YEAR(pathCast.date) | ||
| + | |format=pie chart | ||
| + | |width=350px | ||
| + | |height=350px | ||
| + | |}} | ||
| + | </center> | ||
| + | {{#cargo_query: | ||
| + | |tables=pathCast,subspecialty | ||
| + | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
| + | |fields=subspecialty.hashtag,COUNT(pathCast.subspecialty)=Subspecialty | ||
|format=bar chart | |format=bar chart | ||
|group by=subspecialty.subspecialty | |group by=subspecialty.subspecialty | ||
| Line 90: | Line 101: | ||
|}} | |}} | ||
<br><br> | <br><br> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|Goodbye!}} | |Goodbye!}} | ||
Revision as of 20:20, 8 September 2020
Goodbye!