You are here:
Create Calculated Insights
To create your return insights, go to the Calculated Insights tab in Data 360.
Required Editions
- Click New.
- Select a data space.
- Click Create with SQL, and then click Next.
- For Calculated Insight Name, enter Om Return Rate By Product.
- To use the default data space, use the API name Om_Return_Rate_By_Product__cio. API names are case sensitive. To use a different data space, prefix the API name with the data space’s three character prefix.
-
Enter the SQL Query.
- To use the default data space, enter SELECT ssot__SalesOrderProduct__dlm.ssot__ProductId__c as product__c, SUM(ssot__SalesOrderProduct__dlm.ssot__ProductReturnQuantity__c)/SUM(ssot__SalesOrderProduct__dlm.ssot__AvailableQuantity__c) as return_rate__c FROM ssot__SalesOrderProduct__dlm WHERE ssot__SalesOrderProduct__dlm.ssot__SalesOrderProductSubType__c = 'Product' GROUP BY ssot__SalesOrderProduct__dlm.ssot__ProductId__c
- To use a different data space, build the query according to your data space
- Click Check Syntax. Confirm that it shows Valid Syntax.
- Click Activate. Set a schedule, and then click Enable.
- Click Publish Now. If this option doesn’t show, open the action menu.
Did this article solve your issue?
Let us know so we can improve!
