The Vehicle Revenue From Parts Sales calculated insight aggregates the lifetime revenue
generated from the sale of parts and accessories for a specific vehicle. The vehicle revenue
from parts sales considers the spare parts and accessories sold by the original equipment
manufacturer and the dealerships.
Required Editions
| Available in: Enterprise, Unlimited, and Developer
Editions |
Here’s a breakdown of the logic.
| Expression |
Description |
SELECT
SUM(ssot__LoyaltyTransactionJournal__dlm.ssot__TransactionAmount__c) AS
PartsAmt__c
|
Applies the SUM aggregation function to the Transaction Amount field in the Loyalty
Transaction Journal object and assigns it an alias PartsAmt__c. |
ssot__Vehicle__dlm.ssot__VehicleIdentificationNumber__c AS
VIN__c
|
Extracts the Vehicle Identification Number field from the Vehicle object and assigns it
an alias VIN__c. |
FROM ssot__LoyaltyTransactionJournal__dlm JOIN
ssot__Vehicle__dlm ON
(ssot__LoyaltyTransactionJournal__dlm.ssot__ExternalRecordId__c
|
Joins the data in the Loyalty Transaction Journal and Vehicle objects by matching the
External Record ID field on the Loyalty Transaction Journal to the ID field on the
Vehicle object. |
GROUP BY VIN__c
|
Groups the results by VIN__c, aggregating the
parts sales for each unique vehicle. |
