value_counts
Count occurrences of each distinct value matched by a JSONPath expression, returning a frequency table sorted by count. Use it to find the most common values in JSON data.
Instructions
Count occurrences of each distinct value matched by a JSONPath expression.
Like a frequency table: shows each unique value and how many times it appears. Results are sorted by count (most common first).
Args: alias: The alias of the loaded document. expression: A JSONPath expression (e.g. "$.orders[*].status").
Returns: A frequency table with values and their counts.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| alias | Yes | ||
| expression | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |