The Vehicle Lifetime Value calculated insight aggregates the lifetime revenue generated
from all sales and service activities for a specific vehicle. The lifetime value of a vehicle
includes the sales and service activities of 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 Vehicle_Sales_Detail__cio.VIN__c as
VIN__c
|
Extracts the vehicle identification number from the Vehicle Sales Detail
calculated insight and assigns the value an alias VIN__c. |
SUM(Vehicle_Sales_Detail__cio.DealerSalesAmount__c +
Vehicle_Sales_Detail__cio.DirectSalesAmount__c +
Vehicle_Sales_Detail__cio.PartsTxnAmount__c +
Vehicle_Sales_Detail__cio.RepairOrderAmount__c) as TotalAmount__c
|
Calculates the sum of the dealer sales amount, direct sales amount, parts
transaction amount, and repair order amount for each vehicle and assigns it an alias
TotalAmount__c.
|
FROM Vehicle_Sales_Detail__cio
|
Specifies the source calculated insight that the total amount is derived
from. |
GROUP BY VIN__c
|
Groups the results by VIN__c, aggregating
the revenue for each unique vehicle. |
HAVING
SUM(Vehicle_Sales_Detail__cio.DealerSalesAmount__c +
Vehicle_Sales_Detail__cio.DirectSalesAmount__c +
Vehicle_Sales_Detail__cio.PartsTxnAmount__c +
Vehicle_Sales_Detail__cio.RepairOrderAmount__c) > 0
|
Filters the grouped results to include only the vehicles where the total revenue
is greater than 0. |
