Query sales
query_salesQueries sales metrics from the database: 'ventas_periodo', 'margen', 'ranking_productos', 'por_empleado', or 'historial_cliente'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | No | End date YYYY-MM-DD. Requires 'from'. | |
| from | No | Start date YYYY-MM-DD. Requires 'to'. | |
| limit | No | Max results (default 10, max 50). | |
| preset | No | Preset date range. Mutually exclusive with from/to. | |
| metrica | Yes | Metric to query. | |
| customer_name | No | Customer name or fragment. Only for historial_cliente. |