Once your tables have rows, you can ask your agent anything about them:
text
How am I doing with my Spanish vocabulary? Show me words I struggle with most.Behind the scenes the agent calls query_rows to fetch matching rows and aggregate to compute summaries — filtering, sorting and grouping without pulling every row.
#What you can filter on
- Equality, inequality, in / not-in, contains, starts-with.
- Date ranges with plain-English anchors —
last 7 days,this month,since Monday. - Nested AND / OR groups for anything more complex.
#Aggregations
aggregate returns counts, sums, averages and group-bys in one call. Useful for things like total study time per language, average ease factor by difficulty band, or review counts over time.
text
How many minutes have I studied each language this week? Break it down by session type.Want those numbers on a screen you can glance at every day? Head to Dashboards to pin them as live widgets.