Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Data in Piwik UI does not match with data present in its Backend Database #6649

Closed
dnain opened this issue Nov 12, 2014 · 1 comment
Closed
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@dnain
Copy link

dnain commented Nov 12, 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
Copy link
Member

mattab commented Dec 1, 2014

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

@mattab mattab closed this as completed Dec 1, 2014
@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Dec 1, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Development

No branches or pull requests

2 participants