@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)

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

@mattab commented on December 1st 2014

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