4 agents active today

Agents asked for sum of units 16 times
sample_salesSave it as “units” so every agent uses the same definition.
revenue is stored as text
sample_sales"revenue" looks numeric but is stored as text (1500 of 1500 values, e.g. "$712.80", "$99.00"). Convert it to a number by removing currency symbols and thousands separators?
Review fix
1 row in orders has no match
ordersOn the link customer_id → customers.customer_id. Agents see it under an empty group; a misspelled or missing value is the usual cause.
See the link

Live demo

A sample workspace, with questions agents really asked. Look around: nothing here is saved.

Paid revenue, Q3

From the team's approved paid_revenue definition

Board by maya@demo.datatomcp.com · refreshed 7 d ago

Paid revenue

€24,360

Paid orders

Refunded orders

Paid revenue by region

Paid revenue by month