Dear Forum I am trying to “see” the number of visits and downloads of a journal in year, for this I am consulting the database with the following queries:
SELECT month, SUM(metric) FROM metrics WHERE context_id = 1 AND assoc_type = 256 AND SUBSTR(month,1,4) = 2017 GROUP BY month order by month ASC
SELECT month, SUM(metric) FROM metrics WHERE context_id = 1 AND assoc_type = 259 AND SUBSTR(month,1,4) = 2017 GROUP BY month order by month ASC
Comparing the results with the OJS reports does not match the results.
Can you guide me with the consultation?
OJS 3.0.2