Total terminal transactions by date
SQL query for mWorker
Count the total terminal transactions for each date.
SELECT DATE(TerminalTransactions.date), COUNT(*) FROM TerminalTransactions GROUP BY DATE(TerminalTransactions.date)
mWorker data model
Customer Contacts
Customers
Departments
Employees
Locations
Order Notes
Order Participants
Positions
Product Types
Projects
Suppliers
Tags
Tasks
Task Events
Task Hour Types
Task Expense Types
Terminals
Terminal Transactions
Transport Sites
Users
Vehicles
Contacts
Product Registration
Deliveries
Orders
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