Difference between revisions of "stats"
From pathCast
stats
Line 85: | Line 85: | ||
|tables=pathCast,subspecialty | |tables=pathCast,subspecialty | ||
|join on=pathCast.subspecialty=subspecialty.subspecialty | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
− | |fields=pathCast.date,COUNT(pathCast._pageName) | + | |fields=MONTH(pathCast.date),COUNT(pathCast._pageName) |
|where=YEAR(pathCast.date)='2016' | |where=YEAR(pathCast.date)='2016' | ||
|group by=MONTH(pathCast.date) | |group by=MONTH(pathCast.date) | ||
Line 94: | Line 94: | ||
|tables=pathCast,subspecialty | |tables=pathCast,subspecialty | ||
|join on=pathCast.subspecialty=subspecialty.subspecialty | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
− | |fields=CONCAT(YEAR(pathCast.date),' (',COUNT(pathCast._pageName),')') | + | |fields=CONCAT(YEAR(pathCast.date),' (',COUNT(pathCast._pageName),')'),COUNT(pathCast._pageName) |
|group by=YEAR(pathCast.date) | |group by=YEAR(pathCast.date) | ||
|format=pie chart | |format=pie chart | ||
|}} | |}} | ||
|Goodbye!}} | |Goodbye!}} |
Revision as of 20:18, 8 September 2020
Goodbye!