Menu item performance

1-- core.toast_analytics.menu_item_performance
2-- Toast's Product Mix per menu item and day, with waste and each item's share of
3-- the restaurant's item sales.
4-- Grain: business date x restaurant x menu item.
5--
6-- share_of_item_net_sales is the item's net sales over the sum of all items' net
7-- sales for that restaurant and day. It is a share of item sales, not of the
8-- restaurant's total net sales, which can differ by service charges and other
9-- non-item revenue.
10
11SELECT
12    business_date,
13    restaurant_id,
14    restaurant_name,
15    menu_item_id,
16    menu_item_name,
17    quantity_sold,
18    gross_sales,
19    discounts,
20    net_sales,
21    refunds,
22    voided_amount,
23    waste_quantity,
24    waste_amount,
25    SAFE_DIVIDE(net_sales, quantity_sold)          AS avg_net_price,
26    SAFE_DIVIDE(net_sales, SUM(net_sales) OVER (PARTITION BY restaurant_id, business_date)) AS share_of_item_net_sales
27FROM {{staging.toast_analytics.menu_item}}