Analytics Pivot Query
Instacart interview questions · Hard · Coding round · 6 tests
An online retailer keeps its sales transactions in an analytics warehouse. Every record
contains at least transaction_id, cost, revenue,
category, and date (YYYY-MM-DD). Additional columns such
as region may also be present.
Interface
type TransactionRecord = {
transaction_id: string;
cost: number;
revenue: number;
category: string;
date: string;
region?: string;
[key: string]: unknown;
};
type PivotOptions = {
metric: 'cost' | 'revenue' | 'profit';
region?: string;
startDate?: string;
endDate?: string;
};
class AnalyticsWarehouse {
constructor(records: TransactionRecord[]);
pivotByCategoryMonth(options: PivotOptions): {
months: string[];
rows: Array<{ category: string; values: number[] }>;
};
}Run your code with Ctrl+Enter to see results.