Sales by Hour for Appetize

Description: Sales by Hour displays total sales broken down for all items, primary reporting categories, vendors, and vendor-groups; grouped by either fifteen minutes, thirty minutes, hour, or day. Total sales is calculated by the price of the item (times) the quantity sold (plus) exclusive taxes (plus) tips (plus) fees (minus) discounts (minus) refunds.

---

This report is most often used to review total sales hour-by-hour or in fifteen-minute intervals at end-of-day or after an event. Specific events can be chosen from the filters provided. If there is more than one vendor-group assigned to a specific vendor, sales will duplicate in each vendor-group.

Options

• Start Date/Time: Orders processed from
• End Date/Time: Orders processed until
• Sales Type
  • Gross Sales: item price (times) quantity
  • Net Sales: gross sales (minus) discounts
  • Net Sales (+Tips): net sales (plus) tips
  • Net Revenue: net sales (minus) inclusive tax
  • Total Sales: gross sales (plus) tips (plus) fees (plus) tax (minus) discounts (minus) refunds
• Quantity Type
  • Item Quantity: Root item quantity only
  • Modifier Quantity: Modifier quantity only
  • Total Quantity: Item quantity (plus) modifier quantity
• Date Based On
  
  • Pacific Standard Time: Start/End date based on PST
  • Local Timezone: Start/End date based on timezone set up in venue settings
• Group Time By
  
  • ¼ Hour
  • ½ Hour
  • Hour
  • Day

Filters

• Order ID
• Event Type
• Event Name
• Primary Category
• Item Description
• Vendor Name
• Vendor Group

Measures

• Gross Sales: item price (times) quantity
• Net Sales: gross sales (minus) discounts
• Net Sales (+Tips): net sales (plus) tips
• Net Revenue: net sales (minus) inclusive tax
• Total Sales: gross sales (plus) tips (plus) fees (plus) tax (minus) discounts (minus) refunds
• Exclusive Tax
• Inclusive Tax
• Item Quantity: root item quantity only
• Modifier Quantity: modifier quantity only
• Order Tip
• Total Discounts: order-level discounts (plus) item-level discounts
• Orders: distinct count of order IDs
• Avg. Order: sales Type (divided by) number of distinct orders