@mattab opened this Issue on October 6th 2017 Owner

When applying a user segments involving conversions (such as visit participated in funnel), the number of goal conversions. Here is an example:

No segment applied, numbers are OK.

goal ok

Funnel segment is applied: conversions are multiplied (wrong).

goal not ok

as a result API consumers eg. funnel overview, show the wrong conversions value

goal funnel


-> maybe the issue is because the archiver does not use necessary group by https://github.com/piwik/piwik/blob/3.2.0-b3/core/DataAccess/LogQueryBuilder.php#L68-L77

it likely doesn't use a subselect, but should use a subselect grouped by CONCAT(log_conversion.idvisit, '_' , log_conversion.idgoal, '_', log_conversion.buster) or so.

Powered by GitHub Issue Mirror