opendatasoft_universal_aggregate_records
Aggregate any OpenDataSoft dataset's records using SQL expressions like count, sum, avg, group by, filter, or sort to answer quantitative queries.
Instructions
Run an OpenDataSoft Explore v2.1 aggregate query on any dataset.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| where | No | ||
| select | Yes | Aggregate select expression, e.g. "count(*)", "sum(population)", "avg(value)". | |
| dataset | Yes | ||
| group_by | No | ||
| order_by | No | ||
| portal_url | Yes |