--- title: Hourly Sales Averaged Report description: The Hourly Sales Averaged report provides a breakdown of average sales performance by hour for a selected date range and branch. Instead of showing totals for a single day, this report averages the values across all days in the selected range. This helps identify typical sales patterns, peak hours, and quieter periods, making it useful for staffing, promotions, and operational planning. --- [Skip to content](https://knowledge.techpos.ca/en/knowledge/hourly-sales-averaged-report#main-content) [Customer portal](https://knowledge.techpos.ca/portal?hsLang=en) ![TECHPOS\_Full-Logo\_Brand-Colorsmaller](https://knowledge.techpos.ca/hs-fs/hubfs/TECHPOS_Full-Logo_Brand-Colorsmaller.png?width=500&height=125&name=TECHPOS_Full-Logo_Brand-Colorsmaller.png) Open main navigation Close main navigation - [Customer portal](https://knowledge.techpos.ca/portal) Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://knowledge.techpos.ca/en/knowledge?hsLang=en) 2. [Reports](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en) 3. [Sales Reports](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#sales-reports) # Hourly Sales Averaged Report ## The Hourly Sales Averaged report provides a breakdown of average sales performance by hour for a selected date range and branch. Instead of showing totals for a single day, this report averages the values across all days in the selected range. This helps identify typical sales patterns, peak hours, and quieter periods, making it useful for staffing, promotions, and operational planning. ### **How the Report Works** - The system groups all transactions by **hour of day** (e.g., 9:00–10:00, 10:00–11:00). - For each hour, metrics are **averaged across all days** included in the date range. - The report reflects the *typical performance per hour*, not a single day’s totals. ### **Report Filters** At the top of the report, you can define: - **Start Date / End Date** – The date range used to calculate hourly averages. - **Branch** – The store location the data is pulled from. Once selected, click **View Report** to generate results or **Download CSV** to export the data. ### **Table Columns Explained** #### Hour The time window for each row (e.g., `14:00 – 15:00`). Each row represents the average performance during that hour. #### NetQuan (Average Net Quantity) The average number of items sold per day during that hour. #### NetSale (Average Net Sales) The average net sales value ($) generated during that hour. #### Cost (Average Cost) The average cost of goods sold during that hour. #### Profit (Average Profit) Calculated as: `Profit = Net Sales – Cost` This shows the average profit earned during that hour. #### GP (Gross Profit %) The average gross margin percentage for that hour. `GP% = (Profit / Net Sales) × 100` #### Total Row The **Total** row at the bottom summarizes the overall averages across all hours in the selected range. ### **AG Grid: Filtering & Sorting** The table uses **AG Grid**, which provides powerful filtering and sorting tools directly in the column headers. #### Column Sorting - Click a column header once to sort **ascending**. - Click again to sort **descending**. - Click a third time to clear sorting. - You can sort by any numeric or text column (e.g., NetSale, Profit, GP%). #### Column Filters Each column has a filter input beneath the header: - **Text Filters** (e.g., Hour) - Type part of the value to filter results. - Example: typing `14` will show only `14:00 – 15:00`. - **Number Filters** (NetQuan, NetSale, Cost, Profit, GP%) - Filter by values greater than, less than, or equal to a number. - Example: show only hours where NetSale is greater than $400. #### Clearing Filters - Clear the text or number field to remove a filter. - Sorting and filtering can be combined for deeper analysis. - [Line of Products](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#main-content) - [Express Checkout](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#express-checkout) - [E-Commerce](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#e-commerce) - [Digital Signage](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#digital-signage) - [Cannabis Analytics](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#cannabis-analytics) - [Auto Tag](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#auto-tag) - [Getting Started](https://knowledge.techpos.ca/en/knowledge/getting-started?hsLang=en#main-content) - [Hardware Setup](https://knowledge.techpos.ca/en/knowledge/getting-started?hsLang=en#hardware-setup) - [Online Menu Setup](https://knowledge.techpos.ca/en/knowledge/getting-started?hsLang=en#online-menu-setup) - [Integrations](https://knowledge.techpos.ca/en/knowledge/getting-started?hsLang=en#integrations) - [Business Insights](https://knowledge.techpos.ca/en/knowledge/business-insights?hsLang=en) - [Point of Sale](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#main-content) - [POS Sales Configuration Options](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#pos-sales-configuration-options) - [Opening & Closing The Cash Register](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#opening-closing-the-cash-register) - [Processing In-Store Transactions](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#processing-in-store-transactions) - [Managing Members](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#managing-members) - [Refunds](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#refunds) - [Store Credit](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#store-credit) - [Discounts](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#discounts) - [Payment](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#payment) - [Inventory](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#main-content) - [Products](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#products) - [Categories](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#categories) - [Purchase Orders](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#purchase-orders) - [Warehouse](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#warehouse) - [Bulk Transfer](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#bulk-transfer) - [Product Hub](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#product-hub) - [Inventory Audit](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#inventory-audit) - [Vendor](https://knowledge.techpos.ca/en/knowledge/vendor?hsLang=en) - [Users](https://knowledge.techpos.ca/en/knowledge/users?hsLang=en#main-content) - [Member](https://knowledge.techpos.ca/en/knowledge/users?hsLang=en#member) - [Employee](https://knowledge.techpos.ca/en/knowledge/users?hsLang=en#employee) - [User Role](https://knowledge.techpos.ca/en/knowledge/users?hsLang=en#user-role) - [Member Group/Tiered Membership](https://knowledge.techpos.ca/en/knowledge/users?hsLang=en#member-group-tiered-membership) - [Admin](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#main-content) - [Cash Register](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#cash-register) - [Safe Management](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#safe-management) - [Shifts](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#shifts) - [Schedules](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#schedules) - [Orders](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#orders) - [Marketing](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#marketing) - [Settings](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#settings) - [Reports](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#main-content) - [Sales Reports](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#sales-reports) - [Cash Management](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#cash-management) - [Employee](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#employee) - [Inventory](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#inventory) - [Consolidated Reports](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#consolidated-reports) - [Members](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#members) - [Compliance](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#compliance) - [Pricing](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#main-content) - [Tax Setting](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#tax-setting) - [Campaigns](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#campaigns) - [Combo](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#combo) - [Customized Discount](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#customized-discount) - [Bulk Price Update](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#bulk-price-update) - [Web Menu](https://knowledge.techpos.ca/en/knowledge/web-menu?hsLang=en#main-content) - [Store Rules List](https://knowledge.techpos.ca/en/knowledge/web-menu?hsLang=en#store-rules-list) - [Menu (Categories) List](https://knowledge.techpos.ca/en/knowledge/web-menu?hsLang=en#menu-categories-list) - [Carousel List](https://knowledge.techpos.ca/en/knowledge/web-menu?hsLang=en#carousel-list) - [UI Setting](https://knowledge.techpos.ca/en/knowledge/web-menu?hsLang=en#ui-setting) - [Integrations](https://knowledge.techpos.ca/en/knowledge/integrations?hsLang=en#main-content) - [E-Commerce](https://knowledge.techpos.ca/en/knowledge/integrations?hsLang=en#e-commerce) - [Compliance Report](https://knowledge.techpos.ca/en/knowledge/compliance-report?hsLang=en) - [FAQs](https://knowledge.techpos.ca/en/knowledge/faqs?hsLang=en) - [New Features](https://knowledge.techpos.ca/en/knowledge/new-features?hsLang=en#main-content) - [July 2025](https://knowledge.techpos.ca/en/knowledge/new-features?hsLang=en#july-2025) - [June 2025](https://knowledge.techpos.ca/en/knowledge/new-features?hsLang=en#june-2025) - [May 2025](https://knowledge.techpos.ca/en/knowledge/new-features?hsLang=en#may-2025) - [February 2026](https://knowledge.techpos.ca/en/knowledge/new-features?hsLang=en#february-2026) - [PAT](https://knowledge.techpos.ca/en/knowledge/pat?hsLang=en#main-content) - [Product Auto Tags](https://knowledge.techpos.ca/en/knowledge/pat?hsLang=en#product-auto-tags) [![Chill listening crop-3](https://knowledge.techpos.ca/hs-fs/hubfs/Logo-2021.png?width=175&height=55&name=Logo-2021.png "Chill listening crop-3")](http://techpos.ca) Knowledge Base Copyright © 2026, TechPOS International Corp.