← Back
00:00

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[] }>;
  };
}
Idle