Total sales by month
SQL query for Robaws
Get the total sales amount for each month.
SELECT DATE_FORMAT(sales_date, ‘%Y-%m’) AS month, SUM(total_amount) AS total_sales FROM Sales_Invoices GROUP BY month ORDER BY month
Robaws data model
Work Orders
Vat Tariffs
Transports
Transport Supply Orders
Time Registrations
Tasks
Supply Orders
Suppliers
Subscriptions
Subcontractor Supply Orders
Stock Reservations
Stock Locations
Stock Changes
Settlements
Sales Orders
Sales Invoices
Rental Supply Orders
Purchase Supply Orders
Purchase Invoices
Price Requests
Projects
Project Supply Routes
Price Groups
Posts
Planning Types
Planning Items
Place Transports
Payment Conditions
Offers
Mobility Types
Materials
Legal Forms
Journals
Internal Supply Orders
Installations
Import Jobs
General Ledger Accounts
Employees
Employee Roles
Documents
Delivery Notes
Contacts
Companies
Comments
Clients
Cash Registers
Cash Register Closings
Cash Entries
Bank Payments
Articles
Article Groups
Activities
Absences
Users
Claim States
Recurrence Types
Work Order Time Entries
Work Order Material Entries
Work Order Line Items
Work Order Commute Entries
Post Line Items
Post Parameters
Offer Phases
Offer Parameters
Project Phases
Project Construction Partners
Settlement Phases
Settlement Parameters
Settlement Line Items
Claim State Line Items
Price Request Line Items
Planning Item Line Items
Purchase Supply Order Line Items
Internal Supply Order Line Items
Transport Supply Order Line Items
Rental Supply Order Line Items
Call Off Supply Order Line Items
Article Tier Prices
Employee Certificates
Delivery Note Line Items
Subscription Line Items
Stock Change Articles
Stock Change Materials
Offer Line Items
Offer Line Item Calculation Line Items
Sales Invoice Line Items
Purchase Invoice Line Items
Sales Order Line Items
Subcontractor Supply Order Line Items
Client Contacts
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed