Loading

Identifying The First Product Each Customer Purchased

Julkaisupäivä: Apr 13, 2024
Tehtävä
How to create a field showing the product which each customer purchased for their first order?
Vaiheet
​The following example uses Superstore sample data.
 
  1. Go to Analysis > Create Calculated Field. Name the field First Order Date, enter the following formula, then click OK:
    {FIXED [Customer Name] : MIN([Order Date])}
  2. Create another calculated field named First Purchased Product, enter the following formula, then click OK:
    { FIXED [Customer Name]: 
    MIN(IF [First Order Date] = [Order Date]
    THEN [Product Name] END)}
  3. Place Customer Name, First Order Date and Order Date on Rows.
  4. Place First Purchased Product on Text.
Knowledge-artikkelin numero

001453718

Liitteet

FirstPurchasedProduct.twbx

1217 KB

 
Ladataan
Salesforce Help | Article