qobrix_top_values
Find the most common values in any Qobrix field with counts. Filter records using search expressions and resolve UUIDs to readable names for insights like top developers or lead sources.
Instructions
Aggregate records by a field and return the top N most-frequent values with counts. This tool paginates through all matching records server-side — no client-side scripting needed. Caps at 20,000 records for safety; use a search filter to narrow large datasets. Example uses: Top listing developers: resource='properties', field='developer_id', search='status == "available" and sale_rent == "for_sale"', resolve=true. Lead sources: resource='opportunities', field='source', search='created >= "2026-01-01"'. Agent workload: resource='opportunities', field='owner', search='status == "open"', resolve=true. Property type mix: resource='properties', field='property_type', search='status == "available"'. Set resolve=true to convert UUIDs (developer_id, agent, owner, etc.) to human-readable names.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Number of top values to return (default 10, max 50). Returns the N most-frequent values. | |
| field | Yes | Field name to aggregate by (e.g. 'developer_id', 'agent', 'status', 'source', 'owner', 'city', 'property_type'). Must be a top-level scalar field on the resource. | |
| search | No | Optional Qobrix search expression to filter records before aggregating. Example: 'status == "available" and sale_rent == "for_sale"' to only aggregate active sale listings. | |
| resolve | No | If true, attempt to resolve UUID foreign keys to human-readable names by looking up the referenced entity (Contacts, Agents, Projects, Users). Default false. | |
| resource | Yes | Resource name (case-sensitive, lowercase plural as used by Qobrix API). Values: properties, opportunities, contacts, agents, tasks, property-viewings, projects, offers, contracts, calls, meetings, email-messages. |