Nachi Mehta
04/18/2024, 8:57 PMSELECT SUM(SELECT CASE WHEN {label/ad_funnels.ad_funnel} = \"Branded Search/Google Shopping\" THEN {fact/ad_metrics_pivot.ui_purchase_value} ELSE {fact/sales_metrics_pivot.gross_sales} + {fact/shipping} + {fact/order_tax} END)\r\n"
Any advice here?Moises Morales
04/18/2024, 9:36 PMNachi Mehta
04/18/2024, 9:40 PMIncomparable dimensionalities in a multi-argument node, dimensionality='[dataset/ad_metrics_pivot/0875584c222647ffa3bc520600dd032c, dataset/sales_metrics_pivot/0875584c222647ffa3bc520600dd032c]
Nachi Mehta
04/18/2024, 10:49 PMSELECT SUM({fact/sales_metrics_pivot.gross_sales} + {fact/ad_metrics_pivot.ui_purchase_value})
and I get this error when trying to create an insight:
"reason": "Antichain='[dataset/ad_metrics_pivot/0875584c222647ffa3bc520600dd032c, dataset/sales_metrics_pivot/0875584c222647ffa3bc520600dd032c]' has no witness",
Nachi Mehta
04/18/2024, 10:49 PMMoises Morales
04/18/2024, 11:01 PMJakub Sterba
04/18/2024, 11:54 PMselect sum( select case when {label/a}="a" then sum({fact/x}) else sum({fact/y}) end by {label/label/a} )
or not use CASE at all and use arithmetic instead
e.g.
select ifnull((select sum({fact/x}) where {label/a}="a"),0)+ifnull((select sum({fact/y}) where {label/a}<>"a"),0)
Nachi Mehta
04/19/2024, 3:49 PM