Du er her:
Samkjøpt standardinnsikt for produkter
Denne innsikten bestemmer kjøpte produkter sammen med produktet som for øyeblikket vises.
Når du oppretter denne innsikten, bruker du instruksjonene i Opprette en beregnet innsikt med SQL i Data 360-dokumentasjonen. Du kan deretter legge innsikten i datadiagrammet for nær sanntids elementer i Salesforce Personlig tilpassing.
SELECT
ssot__GoodsProduct__dlm.ssot__Id__c as p1__c,
Table2.productId__c as p2__c,
SUM(Table2.count__c) as countP2__c
FROM
(
SELECT
ssot__SalesOrderProductEngagement__dlm.ssot__ProductId__c as
productId__c,
ssot__ProductOrderEngagement__dlm.ssot__Id__c as orderNumber__c,
count(ssot__SalesOrderProductEngagement__dlm.ssot__Id__c) as
count__c
FROM
ssot__SalesOrderProductEngagement__dlm
JOIN
ssot__ProductOrderEngagement__dlm
ON
ssot__ProductOrderEngagement__dlm.ssot__Id__c =
ssot__SalesOrderProductEngagement__dlm.ssot__ProductOrderEngagementId__c
GROUP BY
ssot__ProductOrderEngagement__dlm.ssot__Id__c,
ssot__SalesOrderProductEngagement__dlm.ssot__ProductId__c
) as Table1
JOIN
(
SELECT
ssot__SalesOrderProductEngagement__dlm.ssot__ProductId__c as
productId__c,
ssot__ProductOrderEngagement__dlm.ssot__Id__c as orderNumber__c,
count(ssot__SalesOrderProductEngagement__dlm.ssot__Id__c) as
count__c
FROM
ssot__SalesOrderProductEngagement__dlm
JOIN
ssot__ProductOrderEngagement__dlm
ON
ssot__ProductOrderEngagement__dlm.ssot__Id__c =
ssot__SalesOrderProductEngagement__dlm.ssot__ProductOrderEngagementId__c
GROUP BY
ssot__ProductOrderEngagement__dlm.ssot__Id__c,
ssot__SalesOrderProductEngagement__dlm.ssot__ProductId__c
) as Table2
ON
Table1.orderNumber__c = Table2.orderNumber__c
JOIN
ssot__GoodsProduct__dlm
ON
ssot__GoodsProduct__dlm.ssot__Id__c = Table1.productId__c
WHERE
Table1.productId__c <> Table2.productId__c
GROUP BY
ssot__GoodsProduct__dlm.ssot__Id__c,
Table2.productId__c
Hjalp denne artikkelen med å løse problemet ditt?
La oss få vite det slik at vi kan forbedre!
