pathCast
Log in

Difference between revisions of "stats"

From pathCast
stats
 
(96 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|
−
<center>{{text|Lectures|||6|}}</center><br>
+
=Lectures=
 +
{{text|{{#cargo_query:
 +
tables=pathCast,faculty,subspecialty
 +
|join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty
 +
|fields=
 +
,CONCAT('{{tabledate{{#urldecode:%7C}}',pathCast.date,'}}')=Date
 +
,CONCAT('[[',faculty._pageName,'|',pathCast.presenter1,', ',faculty.degree,']]')=Presenter
 +
,faculty.institution=Institution
 +
,CONCAT('[[',pathCast._pageName,'|',pathCast.title,']]')=Lecture
 +
,CONCAT('[[',subspecialty._pageName,'|',subspecialty.name,']]')=Subspecialty
 +
,uid=UID
 +
,user=User
 +
,CONCAT('{{pathCastedit{{#urldecode:%7C}}',pathCast._pageName,'}}')=Edit
 +
|order by=pathCast.date DESC
 +
|limit=500
 +
|rows per page=10
 +
|format=dynamic table|}}|||3|}}
 +
 
 +
=Counts ({{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName)|}})=
 +
<table>
 +
<tr>
 +
<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)
+
|fields=CONCAT(YEAR(pathCast.date),' (',COUNT(pathCast._pageName),')'),COUNT(pathCast._pageName)
−
|format=bar chart
+
|group by=YEAR(pathCast.date)
−
|group by=subspecialty.subspecialty
+
|format=pie chart
 +
|width=600px
 +
|height=600px
 
|}}
 
|}}
−
<br><br>
+
</td>
−
<center>{{text|Faculty|||6|}}</center><br>
+
<td>
 
{{#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)
+
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
−
|format=bar chart
+
|group by=MONTH(pathCast.date)
−
|group by=faculty.namefirstlast
+
|}}<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|Lectures|||6|}}</center><br>
+
 
 +
<td>
 +
2017-2019
 
{{#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)
+
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
−
|format=pie chart
+
|group by=MONTH(pathCast.date)
−
|width=900px
+
|where=YEAR(pathCast.date)='2019' OR YEAR(pathCast.date)='2018' OR YEAR(pathCast.date)='2017'
−
|height=900px
 
−
|group by=subspecialty.subspecialty
 
 
|}}
 
|}}
−
<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=pathCast.date,COUNT(pathCast._pageName)
+
|fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count
−
|where=YEAR(pathCast.date)='2020'
 
 
|group by=MONTH(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'
 
|}}
 
|}}
−
<br><br>
+
</td>
 +
 
 +
</tr>
 +
</table>
 +
 
 +
=Faculty ({{#cargo_query: |tables=faculty|fields=COUNT(faculty._pageName)|}})=
 
{{text|{{#cargo_query:
 
{{text|{{#cargo_query:
−
tables=pathCast,faculty,subspecialty
+
tables=faculty
−
|join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty
 
 
|fields=
 
|fields=
−
,CONCAT('{{tabledate{{#urldecode:%7C}}',pathCast.date,'}}')=Date
+
,CONCAT('{{tableFacultyPhoto{{#urldecode:%7C}}',faculty.namefirst,'{{#urldecode:%7C}}',faculty.namelast,'{{#urldecode:%7C}}',faculty._pageName,'{{#urldecode:%7C}}',faculty.degree,'}}')=Faculty
−
,CONCAT('[[',faculty._pageName,'|',pathCast.presenter1,']], ',faculty.degree)=Presenter
+
,institution=Institution
−
,faculty.institution=Institution
 
−
,CONCAT('{{tablelink{{#urldecode:%7C}}',pathCast._pageName,'{{#urldecode:%7C}}',pathCast.title,'{{#urldecode:%7C}}',pathCast.urlyt,'}}')=Lecture
 
−
,CONCAT('[[',subspecialty._pageName,'|',subspecialty.name,']]')=Subspecialty
 
−
|where=DATEDIFF(pathCast.date,NOW())
 
−
|order by=pathCast.date DESC
 
 
|limit=500
 
|limit=500
−
|rows per page=5
+
|rows per page=100
 
|format=dynamic table|}}|||3|}}  
 
|format=dynamic table|}}|||3|}}  
−
|Goodbye!}}
+
<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:
 +
|tables=pathCast,subspecialty
 +
|join on=pathCast.subspecialty=subspecialty.subspecialty
 +
|fields=subspecialty.hashtag,COUNT(pathCast.subspecialty)=Subspecialty
 +
|format=bar chart
 +
|group by=subspecialty.subspecialty
 +
|}}
 +
|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"