Michael DeWulf
12/07/2024, 6:07 PMMichael DeWulf
12/07/2024, 6:08 PMMichael DeWulf
12/07/2024, 8:44 PMSELECT (
SELECT COUNT({label/first_touch_credit.journeyId})
WHERE {label/visited_website_before_purchase} = "true"
AND {label/firstTouchSource} = "google") * (
SELECT SUM({fact/value_origin_breakdown.value}) / count ({label/first_touch_credit.journeyId})
BY ALL OTHER
WITHOUT PF EXCEPT {label/org.id})
Which breaks. However, if you remove the second reference to label/first_touch_credit.journeyId
to get:
SELECT (
SELECT COUNT({label/first_touch_credit.journeyId})
WHERE {label/visited_website_before_purchase} = "true"
AND {label/firstTouchSource} = "google") * (
SELECT SUM({fact/value_origin_breakdown.value}) / 1
BY ALL OTHER
WITHOUT PF EXCEPT {label/org.id})
It works. Just with the wrong value.Michael DeWulf
12/07/2024, 10:10 PMMichael DeWulf
12/07/2024, 10:55 PMIvana Gasparekova
12/09/2024, 9:57 AM