Number of "Goal conversions" may be wrong when applying a segment involving conversions #12158
Labels
Bug
For errors / faults / flaws / inconsistencies etc.
Milestone
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.
Funnel segment is applied: conversions are multiplied (wrong).
as a result API consumers eg. funnel overview, show the wrong conversions value
Notes
-> 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-L77it 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.The text was updated successfully, but these errors were encountered: