exasift
All development updates

From DynamoDB filters to a report

Which overdue orders are over $500, and how many does each region need to follow up on? One set of matches can answer both questions.

Find the orders that need attention

Start with the ten sample orders on the homepage. Give each order a status, a total, and a region. Keep the orders where the status is overdue and the total is greater than $500.

status = "overdue" AND total > 500

Six orders match. An overdue order for $318.50 falls below the threshold. A paid order for $760 also stays out. The result is a list someone can act on.

Count the same matches by region

Take those six orders, group them by region, and count the rows in each group. The report answers where the work is concentrated. The matching rows show which orders make up each count.

Matching sample orders by region
RegionOrders
North America4
Europe2
Total6

Try turning off the amount filter in the interactive orders example. The overdue order for $318.50 joins the results, and Europe’s count increases. You can see how changing one condition affects both the list and the report.

Bring a query to the pilot

If you already filter DynamoDB records to answer a recurring question, tell us which attributes you filter on and what you need to count or group.

Join the waitlist