Oh, always so challenging things to solve/figure out.
But at the same time, very interesting, don’t you think. 
We do consider a bot list (s. lib/pkp/lib/counterBots/generated/COUNTER_Robots_list.txt).
We differentiate between abstract page and file views.
We count after COUNTER rules - in that OJS version this means we do consider double clicks.
Didn’t know we were filtering bots. Thanks to clarify.
The first thing that comes to my mind for this specific case is that you maybe use/have used both, internal and apache log files - I remember one issue from you, with the apache log files (the aliases above), where we realized that you actually also have the internal OJS log files. Only one, either OJS or apache log files should be used.
Yep. Possibly in this thread, isn’t it?
Thus, maybe to first double check your DB table metrics:
What do you see as load_id there, e.g. with SELECT DISTINCT load_id FROM metrics ?
Of course. It returns all usarge_events ids since 2015 (a total of 2,766 rows), and two extra files with counter and ojsViews data from 2.4.2.
In case it’s useful, I’m passing you the full list in a pastebin: https://pastebin.com/vRaddGUa
And lets take a look at those specific dates from above: What do you get as result for this query: SELECT DISTINCT load_id FROM metrics WHERE day = ‘20230315’ ?
This query only returns the log for 3/15/2023:
OK, lets first see these - maybe they will already tell us something more - before we think about/try other things…
Great. Thanks for everything, Bozana.
(But no hurry with this, please… now the priority is 3.4 and I suspect you have your hands full).
Take care,
m.