Loading analytics…
Daily Revenue Trend
Delivered-order payment revenue by order date.
payments.amount
Loading analytics…
Revenue by Category
Delivered sales value = quantity × product price.
qty × price
Loading analytics…
Revenue Contribution by Category
Category sales value as a share of total delivered sales value (same qty × price metric on both sides).
ROUND(%, 2)
Loading analytics…
Top 5 Products by Revenue
Highest delivered sales value per product.
LIMIT 5
Loading analytics…
Payment Method Analysis
Delivered transactions and revenue by payment mode.
payments
Loading analytics…
City-wise Revenue
Delivered payment revenue by customer city.
customers.city
Loading analytics…
Order Status Distribution
Share of orders by status across the full order book.
COUNT(*) %
Loading analytics…
Best-selling Products
Units sold per product across delivered orders.
SUM(quantity)
Loading analytics…