Difference between revisions of "stats"
From pathCast
stats
| Line 41: | Line 41: | ||
{{text|Total: {{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName)|}}||red|}}|||4|}} | {{text|Total: {{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName)|}}||red|}}|||4|}} | ||
</td> | </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' | ||
| + | |}}<br> | ||
| + | {{text|Total: {{text|{{#cargo_query: |tables=pathCast,subspecialty |join on=pathCast.subspecialty=subspecialty.subspecialty |fields=COUNT(pathCast._pageName)|}}||red|}}|||4|}} | ||
| + | </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> | ||
| + | |||
</tr> | </tr> | ||
</table> | </table> | ||
Revision as of 12:02, 16 September 2020
If you are an admin, log in.