pathCast
Log in

Difference between revisions of "stats"

From pathCast
stats
 
(69 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|
 +
=Lectures=
 
{{text|{{#cargo_query:
 
{{text|{{#cargo_query:
 
tables=pathCast,faculty,subspecialty
 
tables=pathCast,faculty,subspecialty
Line 6: Line 7:
 
|fields=
 
|fields=
 
,CONCAT('{{tabledate{{#urldecode:%7C}}',pathCast.date,'}}')=Date
 
,CONCAT('{{tabledate{{#urldecode:%7C}}',pathCast.date,'}}')=Date
−
,CONCAT('[[',faculty._pageName,'|',pathCast.presenter1,']], ',faculty.degree)=Presenter
+
,CONCAT('[[',faculty._pageName,'|',pathCast.presenter1,', ',faculty.degree,']]')=Presenter
 
,faculty.institution=Institution
 
,faculty.institution=Institution
 
,CONCAT('[[',pathCast._pageName,'|',pathCast.title,']]')=Lecture
 
,CONCAT('[[',pathCast._pageName,'|',pathCast.title,']]')=Lecture
 
,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)|}})=
−
<center>{{#cargo_query:
+
<table>
 +
<tr>
 +
<td>
 +
{{#cargo_query:
 
|tables=pathCast,subspecialty
 
|tables=pathCast,subspecialty
 
|join on=pathCast.subspecialty=subspecialty.subspecialty
 
|join on=pathCast.subspecialty=subspecialty.subspecialty
Line 25: Line 31:
 
|width=600px
 
|width=600px
 
|height=600px
 
|height=600px
−
|}}</center>
+
|}}
 +
</td>
 +
<td>
 
{{#cargo_query:
 
{{#cargo_query:
 
|tables=pathCast,subspecialty
 
|tables=pathCast,subspecialty
 
|join on=pathCast.subspecialty=subspecialty.subspecialty
 
|join on=pathCast.subspecialty=subspecialty.subspecialty
−
|fields=subspecialty.hashtag,COUNT(pathCast.subspecialty)=Subspecialty
+
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
−
|format=bar chart
+
|group by=MONTH(pathCast.date)
−
|group by=subspecialty.subspecialty
+
|}}<br>
−
|}}
+
{{text|Total: {{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName)|}}||red|}}|||4|}}
−
<br><br>
+
</td>
−
<center>{{text|Faculty|||6|}}</center><br>
+
 
 +
<td>
 +
2017-2019
 
{{#cargo_query:
 
{{#cargo_query:
−
|tables=pathCast,faculty
+
|tables=pathCast,subspecialty
−
|join on=pathCast.presenter1=faculty.namefirstlast
+
|join on=pathCast.subspecialty=subspecialty.subspecialty
−
|fields=faculty.namefirstlast,COUNT(pathCast.presenter1)=Faculty
+
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
−
|format=bar chart
+
|group by=MONTH(pathCast.date)
−
|group by=faculty.namefirstlast
+
|where=YEAR(pathCast.date)='2019' OR YEAR(pathCast.date)='2018' OR YEAR(pathCast.date)='2017'
 
|}}
 
|}}
−
<br><br>
+
</td>
−
<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>
+
 
 +
<td>
 +
2017
 
{{#cargo_query:
 
{{#cargo_query:
 
|tables=pathCast,subspecialty
 
|tables=pathCast,subspecialty
 
|join on=pathCast.subspecialty=subspecialty.subspecialty
 
|join on=pathCast.subspecialty=subspecialty.subspecialty
−
|fields=MONTH(pathCast.date),COUNT(pathCast._pageName)
+
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
−
|group by=YEAR(pathCast.date)
+
|group by=MONTH(pathCast.date)
 +
|where=YEAR(pathCast.date)='2017'
 
|}}
 
|}}
−
<br><br>
+
</td>
−
<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>
+
 
 +
<td>
 +
2018
 
{{#cargo_query:
 
{{#cargo_query:
 
|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)=Month,COUNT(pathCast._pageName)=Count
−
|where=YEAR(pathCast.date)='2019'
 
 
|group by=MONTH(pathCast.date)
 
|group by=MONTH(pathCast.date)
 +
|where=YEAR(pathCast.date)='2018'
 
|}}
 
|}}
−
<br><br>
+
</td>
−
<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>
+
 
 +
<td>
 +
2019
 
{{#cargo_query:
 
{{#cargo_query:
 
|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)=Month,COUNT(pathCast._pageName)=Count
−
|where=YEAR(pathCast.date)='2018'
 
 
|group by=MONTH(pathCast.date)
 
|group by=MONTH(pathCast.date)
 +
|where=YEAR(pathCast.date)='2019'
 
|}}
 
|}}
−
<br><br>
+
</td>
−
<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>
+
 
 +
<td>
 +
2020
 
{{#cargo_query:
 
{{#cargo_query:
 
|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)=Month,COUNT(pathCast._pageName)=Count
−
|where=YEAR(pathCast.date)='2017'
 
 
|group by=MONTH(pathCast.date)
 
|group by=MONTH(pathCast.date)
 +
|where=YEAR(pathCast.date)='2020'
 
|}}
 
|}}
 +
</td>
 +
 +
</tr>
 +
</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>
 
<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=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
 
|join on=pathCast.subspecialty=subspecialty.subspecialty
 
|join on=pathCast.subspecialty=subspecialty.subspecialty
−
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
+
|fields=subspecialty.hashtag,COUNT(pathCast.subspecialty)=Subspecialty
−
|where=YEAR(pathCast.date)='2016'
+
|format=bar chart
−
|group by=MONTH(pathCast.date)
+
|group by=subspecialty.subspecialty
 
|}}
 
|}}
−
|Goodbye!}}
+
|If you are an admin, log in.}}

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"