Difference between revisions of "stats"
From pathCast
stats
(95 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| |
+ | =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,' | + | ,CONCAT('[[',faculty._pageName,'|',pathCast.presenter1,', ',faculty.degree,']]')=Presenter |
,faculty.institution=Institution | ,faculty.institution=Institution | ||
− | ,CONCAT(' | + | ,CONCAT('[[',pathCast._pageName,'|',pathCast.title,']]')=Lecture |
,CONCAT('[[',subspecialty._pageName,'|',subspecialty.name,']]')=Subspecialty | ,CONCAT('[[',subspecialty._pageName,'|',subspecialty.name,']]')=Subspecialty | ||
− | + | ,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= | + | |rows per page=10 |
− | |format=dynamic table|}}||| | + | |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= | + | |fields=CONCAT(YEAR(pathCast.date),' (',COUNT(pathCast._pageName),')'),COUNT(pathCast._pageName) |
− | |format= | + | |group by=YEAR(pathCast.date) |
− | | | + | |format=pie chart |
+ | |width=600px | ||
+ | |height=600px | ||
|}} | |}} | ||
− | < | + | </td> |
− | < | + | <td> |
+ | {{#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) | ||
+ | |}}<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: | {{#cargo_query: | ||
− | |tables=pathCast, | + | |tables=pathCast,subspecialty |
− | |join on=pathCast. | + | |join on=pathCast.subspecialty=subspecialty.subspecialty |
− | |fields= | + | |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: | {{#cargo_query: | ||
|tables=pathCast,subspecialty | |tables=pathCast,subspecialty | ||
|join on=pathCast.subspecialty=subspecialty.subspecialty | |join on=pathCast.subspecialty=subspecialty.subspecialty | ||
− | |fields= | + | |fields=MONTH(pathCast.date)=Month,COUNT(pathCast._pageName)=Count |
− | + | |group by=MONTH(pathCast.date) | |
− | | | + | |where=YEAR(pathCast.date)='2017' |
− | | | ||
− | |||
|}} | |}} | ||
− | < | + | </td> |
− | + | ||
+ | <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 |
− | |||
|group by=MONTH(pathCast.date) | |group by=MONTH(pathCast.date) | ||
+ | |where=YEAR(pathCast.date)='2018' | ||
|}} | |}} | ||
− | < | + | </td> |
− | + | ||
+ | <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 |
+ | |group by=MONTH(pathCast.date) | ||
|where=YEAR(pathCast.date)='2019' | |where=YEAR(pathCast.date)='2019' | ||
− | |||
|}} | |}} | ||
− | < | + | </td> |
− | + | ||
+ | <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 |
− | |||
|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> | ||
− | + | {{#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= | + | |fields=subspecialty.hashtag,COUNT(pathCast.subspecialty)=Subspecialty |
− | | | + | |format=bar chart |
− | |group by= | + | |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.