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

Jump to bottom

date range from xx.03. to 31.03. returns wrong visit results #14301

Closed
blackCapy opened this issue Apr 1, 2019 · 8 comments
Closed

date range from xx.03. to 31.03. returns wrong visit results #14301

blackCapy opened this issue Apr 1, 2019 · 8 comments
Labels
answered For when a question was asked and we referred to forum or answered it. Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users.

Comments

@blackCapy
Copy link

The 31st of march seems to be buggy then I use date range filter. It looks like the day has a negative value. This is only the case if the from is a date of march and the to is exactly 31.03. (so 28.02 - 31.03. looks good).
The result values are from Visitor Map and Visitors Overview.

customer 1:
01.03. - 30.03. -> 8,904 visits
01.03. - 31.03. -> 5,680 visits
28.02. - 31.03. -> 9,521 visits

customer 2:
01.03. - 30.03. -> 39,171 visits
01.03. - 31.03. -> 30,105 visits
28.02. - 31.03. -> 48,457 visits

Maybe it's an issue with the switch from winter time to summer time. On 31.03. at 3:00 am the clock was set to 2:00 am.
@blackCapy
Copy link
Author

One more example. For the date range of 25.03. to 31.03. is the result 0, but from 26.03. to 31.03. it is 8,500.

@sgiehl
Copy link
Member

sgiehl commented Apr 1, 2019

does that only happen when choosing a range? Or is the number also incorrect if you select a week/month including the 31.03.?

@blackCapy
Copy link
Author

Then I select the week of 31.03. or the month march anything looks fine.
date range: 25.03. - 31.03. -> 0 visits
week (from 25.03. to 31.03.) -> 10,301 visits

date range: 01.03. - 31.03. -> 30,105 visits
month (march) -> 46,953 visits

@blackCapy
Copy link
Author

I got a mail from that customer. He wrote that the sum of the single days (18., 19., 20., 21., 22., 23. and 24.03.) is 9,996. Then he use the range filter the result of these days is 3,528.
So it's not the 31.03. It is a general date range issue.

@tsteur
Copy link
Member

tsteur commented Apr 1, 2019

Could you try to invalidate the reports and reprocess them? see eg https://matomo.org/faq/how-to/faq_155/ curious if this fixes the issue.

@blackCapy
Copy link
Author

Actually we move our matomo server into our new infrastructure. Then I will try it.

@tsteur tsteur added the Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users. label Apr 11, 2019
@mattab
Copy link
Member

mattab commented Jan 21, 2020

@allesmeins89 could you please try again if you still experience this issue?

It would be great to hear confirmation if the issue is still active for you. (fyi there is another similar - but different - issue at #15363

This one may also be a duplicate of #14123

@blackCapy
Copy link
Author

Looks like it will work.

@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Feb 10, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
answered For when a question was asked and we referred to forum or answered it. Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@tsteur @mattab @sgiehl @blackCapy