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

wrong statistics when filtering country #5903

Closed
bglxx opened this issue Aug 1, 2014 · 15 comments
Closed

wrong statistics when filtering country #5903

bglxx opened this issue Aug 1, 2014 · 15 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. worksforme The issue cannot be reproduced and things work as intended.

Comments

@bglxx
Copy link

bglxx commented Aug 1, 2014

The results in "Visitors / Locations & Provider" statistics are wrong for July. Older months are okay.

I have set a segment filter:
Country contains de
OR
Country contains ch
OR
Country contains at

to select the German speaking countries.

When I select "Visitors / Locations & Provider" without filtering, the country statistics are okay.

When I activate the segment filter, the county statistics are much to low. For example:
Without filter: 1379 visitors from Germany
With filter: 280 visitors from Germany

When I select the month June ore before, the statistics are okay.

Piwik Version is 2.4.1
PHP is 5.5.11
Mysql is MariaDB 5.5.37

@sgiehl
Copy link
Member

sgiehl commented Aug 3, 2014

Which location provider are you using? Any GeoIP db or the Piwik built-in 'detection'?

@mattab
Copy link
Member

mattab commented Aug 3, 2014

@bglxx maybe you could post the screenshot of reports with and without segment?

@mattab mattab added the Bug label Aug 3, 2014
@mattab mattab added this to the Short term milestone Aug 3, 2014
@bglxx
Copy link
Author

bglxx commented Aug 4, 2014

@sgiehl I'm using GeoIP (Php)

@bglxx
Copy link
Author

bglxx commented Aug 4, 2014

@mattab I've made several tests and the wrong results are from July 3rd until July 28th. All data before and after is okay.

Enclosed you will find the pics from June (results are okay) with and without filter, and wrong data from July and the filter conditions.

visitors-loc-and-prov-june-with-filter
visitors-loc-and-prov-june-without-filter
visitors-loc-and-prov-july-with-filter
visitors-loc-and-prov-july-without-filter
filter-conditions

@daincredibleholg
Copy link

I've created the new issue #5998 with the content of this comment. Sorry for "hijacking".

@mattab
Copy link
Member

mattab commented Aug 13, 2014

@daincredibleholg please don't hijack this bug report with your bug report! They could be un-related and it would be better to create a separate bug report. Would you mind?

@daincredibleholg
Copy link

@mattab Sorry, hijacking was not in my mind. It really looks related, this is why I have added my details instead of opening a new bug. So, sorry for that. I will open a new one.

@mattab
Copy link
Member

mattab commented Aug 13, 2014

@daincredibleholg no worries, thanks (please write somewhere in bug report this #5903 and it will automatically link both tickets together)

@bglxx
Copy link
Author

bglxx commented Sep 1, 2014

I have new information regarding this issue:

The problem with the wrong statistics data is again here in August, so it
seems not to be caused by damaged data.

For example: Selected date range Aug-01 until Aug-14

Without segmentation of the visitors the data shown at "Visitors /
Locations & Provider" is correct.

When I activate the segmentation (Visit Location Country contains "de") -
the data is also okay.

When I activate segmentation Country contains "de" or Country contains "ch"
or Country contains "at" - the displayed statistic is wrong.

Now I have changed the segmentation from "de - ch - at" to "at - ch - de"
and the displayed data is okay. Same with "de - at - ch", also okay.

@mattab
Copy link
Member

mattab commented Dec 1, 2014

Hi @bglxx do you still experience the issue with Piwik 2.9.1?

@bglxx
Copy link
Author

bglxx commented Dec 1, 2014

Hi @mattab,

I'm using 2.9.1 and the problem is still there too.

Page is Visitors / Locations & Provider. The number of visits on the visitor map is okay, but the row "Country" shows wrong values depending on the filter. Values are either okay or too low.

When I change the order of countries in my filter, the results are changing. I've checked it for last week and for last month and the problem is the same. Here are the screen prints:

First pic is okay, second one is wrong.

piwik_02

piwik_01

Have a nice day.

@tsteur
Copy link
Member

tsteur commented Feb 5, 2015

Do you use the log importer or the normal Piwik JavaScript tracker?

Do you know if you have browser archiving enabled or do you archive via the CLI (php console core:archive)?

I tried to reproduce but couldn't. The only thing that would explain this to me would be a problem with archive invalidation or so. Meaning an archive was created at some point but not invalidated and not rearchived afterwards. That would explain why it works with a different order of the countries as they were not archived yet. Is it maybe possible to get access to your Piwik installation and also to your database? If so, can you send us the credentials to hello (at) piwik.org?

@bglxx
Copy link
Author

bglxx commented Feb 19, 2015

sorry for the late reply.
we use regular Piwik JavaScript tracker and there was no log import ever.

since now we have the default settings for piwik archiver (allow piwik archiving to trigger..." = yes)

do u need access to root level console or to the piwik website?

@mattab
Copy link
Member

mattab commented Apr 7, 2015

Hi @bglxx can you still reproduce this issue with the latest Piwik stable version?

@bglxx
Copy link
Author

bglxx commented Apr 7, 2015

Hi @mattab
I've tried all known combinations that triggers the error before and now it works well.

My version is 2.12.1 and I suggest to close this bug. I will monitor it in future if this prob is coming back.

@sgiehl sgiehl closed this as completed Apr 7, 2015
@mattab mattab added the worksforme The issue cannot be reproduced and things work as intended. label Apr 7, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. worksforme The issue cannot be reproduced and things work as intended.
Projects
None yet
Development

No branches or pull requests

5 participants