|
|
Line 55: |
Line 55: |
| |format=bar chart | | |format=bar chart |
| |group by=faculty.namefirstlast | | |group by=faculty.namefirstlast |
− | |}}
| |
− | <br><br>
| |
− | <center>{{text|By year: 2020 ({{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName) |where=YEAR(pathCast.date)='2020' |}}||red|}})|||6|}}</center><br>
| |
− | {{#cargo_query:
| |
− | |tables=pathCast,subspecialty
| |
− | |join on=pathCast.subspecialty=subspecialty.subspecialty
| |
− | |fields=MONTH(pathCast.date)=Month,YEAR(pathCast.date)=Year,COUNT(pathCast._pageName)=Count
| |
− | |group by=MONTH(pathCast.date)
| |
− | |}}
| |
− | <br><br>
| |
− | <center>{{text|By year: 2019 ({{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName) |where=YEAR(pathCast.date)='2019' |}}||red|}})|||6|}}</center><br>
| |
− | {{#cargo_query:
| |
− | |tables=pathCast,subspecialty
| |
− | |join on=pathCast.subspecialty=subspecialty.subspecialty
| |
− | |fields=pathCast.date,COUNT(pathCast._pageName)
| |
− | |where=YEAR(pathCast.date)='2019'
| |
− | |group by=MONTH(pathCast.date)
| |
− | |}}
| |
− | <br><br>
| |
− | <center>{{text|By year: 2018 ({{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName) |where=YEAR(pathCast.date)='2018' |}}||red|}})|||6|}}</center><br>
| |
− | {{#cargo_query:
| |
− | |tables=pathCast,subspecialty
| |
− | |join on=pathCast.subspecialty=subspecialty.subspecialty
| |
− | |fields=pathCast.date,COUNT(pathCast._pageName)
| |
− | |where=YEAR(pathCast.date)='2018'
| |
− | |group by=MONTH(pathCast.date)
| |
− | |}}
| |
− | <br><br>
| |
− | <center>{{text|By year: 2017 ({{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName) |where=YEAR(pathCast.date)='2017' |}}||red|}})|||6|}}</center><br>
| |
− | {{#cargo_query:
| |
− | |tables=pathCast,subspecialty
| |
− | |join on=pathCast.subspecialty=subspecialty.subspecialty
| |
− | |fields=pathCast.date,COUNT(pathCast._pageName)
| |
− | |where=YEAR(pathCast.date)='2017'
| |
− | |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=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
| |
− | |where=YEAR(pathCast.date)='2016'
| |
− | |group by=MONTH(pathCast.date)
| |
| |}} | | |}} |
| |Goodbye!}} | | |Goodbye!}} |