pathCast
Log in

Difference between revisions of "stats"

From pathCast
stats
 
(46 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
{{DISPLAYTITLE:pathCast: Analytics}}
+
{{DISPLAYTITLE:pathCast: Analytics}}{{#css: .fc-unthemed td.fc-today { background: #b9ecff; } .fc-event {font-size: 1.05em; } a.fc-event:visited { color: #FFF; } }}
−
{{IfGroup|sysop|
+
{{#ifgroup:sysop|
−
{{#cargo_query:
+
=Lectures=
−
tables=pathCast
 
−
|fields=date,_pageName,title=name
 
−
|width=300
 
−
|color=#ffb973
 
−
|format=calendar
 
−
|}}
 
 
{{text|{{#cargo_query:
 
{{text|{{#cargo_query:
 
tables=pathCast,faculty,subspecialty
 
tables=pathCast,faculty,subspecialty
Line 18: Line 12:
 
,CONCAT('[[',subspecialty._pageName,'|',subspecialty.name,']]')=Subspecialty
 
,CONCAT('[[',subspecialty._pageName,'|',subspecialty.name,']]')=Subspecialty
 
,uid=UID
 
,uid=UID
 +
,user=User
 +
,CONCAT('{{pathCastedit{{#urldecode:%7C}}',pathCast._pageName,'}}')=Edit
 
|order by=pathCast.date DESC
 
|order by=pathCast.date DESC
 
|limit=500
 
|limit=500
−
|rows per page=15
+
|rows per page=10
 
|format=dynamic table|}}|||3|}}  
 
|format=dynamic table|}}|||3|}}  
−
<br><br>
+
 
−
<center>{{text|Lectures ({{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName)|}}||red|}})|||6|}}</center><br>
+
=Counts ({{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName)|}})=
 
<table>
 
<table>
 
<tr>
 
<tr>
Line 43: Line 39:
 
|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>
 +
{{text|Total: {{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName)|}}||red|}}|||4|}}
 +
</td>
 +
 +
<td>
 +
2017-2019
 +
{{#cargo_query:
 +
|tables=pathCast,subspecialty
 +
|join on=pathCast.subspecialty=subspecialty.subspecialty
 +
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
 +
|group by=MONTH(pathCast.date)
 +
|where=YEAR(pathCast.date)='2019' OR YEAR(pathCast.date)='2018' OR YEAR(pathCast.date)='2017'
 +
|}}
 +
</td>
 +
 +
<td>
 +
2017
 +
{{#cargo_query:
 +
|tables=pathCast,subspecialty
 +
|join on=pathCast.subspecialty=subspecialty.subspecialty
 +
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
 +
|group by=MONTH(pathCast.date)
 +
|where=YEAR(pathCast.date)='2017'
 +
|}}
 +
</td>
 +
 +
<td>
 +
2018
 +
{{#cargo_query:
 +
|tables=pathCast,subspecialty
 +
|join on=pathCast.subspecialty=subspecialty.subspecialty
 +
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
 +
|group by=MONTH(pathCast.date)
 +
|where=YEAR(pathCast.date)='2018'
 +
|}}
 +
</td>
 +
 +
<td>
 +
2019
 +
{{#cargo_query:
 +
|tables=pathCast,subspecialty
 +
|join on=pathCast.subspecialty=subspecialty.subspecialty
 +
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
 +
|group by=MONTH(pathCast.date)
 +
|where=YEAR(pathCast.date)='2019'
 +
|}}
 +
</td>
 +
 +
<td>
 +
2020
 +
{{#cargo_query:
 +
|tables=pathCast,subspecialty
 +
|join on=pathCast.subspecialty=subspecialty.subspecialty
 +
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
 +
|group by=MONTH(pathCast.date)
 +
|where=YEAR(pathCast.date)='2020'
 
|}}
 
|}}
 
</td>
 
</td>
 +
 
</tr>
 
</tr>
 
</table>
 
</table>
 +
 +
=Faculty ({{#cargo_query: |tables=faculty|fields=COUNT(faculty._pageName)|}})=
 +
{{text|{{#cargo_query:
 +
tables=faculty
 +
|fields=
 +
,CONCAT('{{tableFacultyPhoto{{#urldecode:%7C}}',faculty.namefirst,'{{#urldecode:%7C}}',faculty.namelast,'{{#urldecode:%7C}}',faculty._pageName,'{{#urldecode:%7C}}',faculty.degree,'}}')=Faculty
 +
,institution=Institution
 +
|limit=500
 +
|rows per page=100
 +
|format=dynamic table|}}|||3|}}
 +
<headertabs/>
 +
<br><br>
 +
{{#cargo_query:
 +
tables=pathCast,subspecialty
 +
|join on=pathCast.subspecialty=subspecialty.subspecialty
 +
|fields=pathCast.date,pathCast._pageName,CONCAT(subspecialty.hashtag,' - ',pathCast.title)=name
 +
|format=calendar
 +
|view=month
 +
|}}
 +
<br>
 
{{#cargo_query:
 
{{#cargo_query:
 
|tables=pathCast,subspecialty
 
|tables=pathCast,subspecialty
Line 54: Line 127:
 
|group by=subspecialty.subspecialty  
 
|group by=subspecialty.subspecialty  
 
|}}
 
|}}
−
<br><br>
+
|If you are an admin, log in.}}
−
<center>{{text|Faculty|||6|}}</center><br>
 
−
{{#cargo_query:
 
−
|tables=pathCast,faculty
 
−
|join on=pathCast.presenter1=faculty.namefirstlast
 
−
|fields=faculty.namefirstlast,COUNT(pathCast.presenter1)=Faculty
 
−
|format=bar chart
 
−
|group by=faculty.namefirstlast
 
−
|}}
 
−
|Goodbye!}}
 

Latest revision as of 17:46, 3 November 2020

If you are an admin, log in.

Retrieved from "https://pathologycast.com/index.php?title=stats&oldid=2990"