pathCast
Log in

Difference between revisions of "stats"

From pathCast
stats
Line 49: Line 49:
 
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
 
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
 
|group by=MONTH(pathCast.date)
 
|group by=MONTH(pathCast.date)
|where=YEAR(pathCast.date)='2019' AND YEAR(pathCast.date)='2018' AND YEAR(pathCast.date)='2017'
+
|where=YEAR(pathCast.date)='2019' OR YEAR(pathCast.date)='2018' OR YEAR(pathCast.date)='2017'
|}}<br>
+
|}}
{{text|Total: {{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName)|}}||red|}}|||4|}}
 
 
</td>
 
</td>
  
 
<td>
 
<td>
 +
2020
 
{{#cargo_query:
 
{{#cargo_query:
 
|tables=pathCast,subspecialty
 
|tables=pathCast,subspecialty
Line 60: Line 60:
 
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
 
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
 
|group by=MONTH(pathCast.date)
 
|group by=MONTH(pathCast.date)
|}}<br>
+
|where=YEAR(pathCast.date)='2020'
{{text|Total: {{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName)|}}||red|}}|||4|}}
+
|}}
 
</td>
 
</td>
  

Revision as of 12:03, 16 September 2020

If you are an admin, log in.