@dnain opened this Issue on November 12th 2014

Visit , Vistor data from the backend doesn't reconcile with data in UI.

Date DbCount UICount
9/1/2014 2277 2262
9/2/2014 3029 3004
9/3/2014 2843 2852
9/4/2014 2756 2514
9/5/2014 2480 2514
9/6/2014 102 114
9/7/2014 208 187

Backend Sql (Database is MySql)
SELECT
date(visit_first_action_time) as Visitday
,count(idvisit) as CountVisit
FROM piwik413.piwik_log_visit
Group by date(visit_first_action_time)
Order By date(visit_first_action_time)

visit_piwik_reader

Could you please let me know the possible causes for this anomaly

@mattab commented on December 1st 2014 Owner

Hi @dnain Piwik records datetimes in UTC timezone so please change your date to UTC before applying queries on DB :+1:

This Issue was closed on December 1st 2014
Powered by GitHub Issue Mirror