Difference between revisions of "stats"
From pathCast
stats
Line 38: | Line 38: | ||
|tables=pathCast,faculty | |tables=pathCast,faculty | ||
|join on=pathCast.presenter1=faculty.namefirstlast | |join on=pathCast.presenter1=faculty.namefirstlast | ||
− | |fields=faculty.namefirstlast,COUNT(pathCast.presenter1) | + | |fields=faculty.namefirstlast,COUNT(pathCast.presenter1)=Faculty |
|format=bar chart | |format=bar chart | ||
|group by=faculty.namefirstlast | |group by=faculty.namefirstlast | ||
Line 47: | Line 47: | ||
|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) |
+ | |format=bar chart | ||
|where=YEAR(pathCast.date)='2020' | |where=YEAR(pathCast.date)='2020' | ||
|group by=MONTH(pathCast.date) | |group by=MONTH(pathCast.date) |
Revision as of 20:25, 8 September 2020
Goodbye!