1. How would you identify customers who have purchased from multiple product categories?
Count distinct categories purchased by each customer and filter those with more than one category.
Example:
{ FIXED [Customer ID] : COUNTD([Category]) } > 1
2. How would you calculate the percentage of orders delivered within SLA?
Count orders delivered within SLA and divide by total orders.
Example:
SUM(
IF DATEDIFF('day',[Order Date],[Ship Date]) <= 3
THEN 1
ELSE 0
END
)
/
COUNT([Order ID])
3. How would you identify the highest-selling product in each category?
Rank products by sales within each category.
Example:
RANK(SUM([Sales])) = 1
Compute Using: Product
Partition By: Category
4. How would you calculate average days between customer purchases?
Find the difference between consecutive orders and average them.
Example:
WINDOW_AVG(
DATEDIFF(
'day',
LOOKUP(MIN([Order Date]),-1),
MIN([Order Date])
)
)
5. How would you identify customers whose profit margin is below 5%?
Calculate profit margin and filter low-margin customers.
Example:
SUM([Profit])
/
SUM([Sales])
< 0.05
This highlights customers generating sales but very little profit.
