Last week I had one day where Piwik says there were no visits. I knew that wasn’t true so I ran
`SELECT COUNT(*) FROM piwik_log_visit WHERE visit_last_action_time > ‘2016-03-04 00:00:00’ AND visit_last_action_time < ‘2016-03-05 00:00:00’
Which`of course gave me the 2m entries I was expecting. Why is that day missing from Piwik reports and what can be done?
My local TZ is UTC too so that is moot. I have just run the invalidation and what I am seeing is very curious. No pageviews or visitors for that day but all the Events have been tracked. How might that be possible?