Get Board Insights
board_insightsCalculate insights from board data by filtering, grouping, and aggregating columns. Get summaries like item counts per status or column.
Instructions
This tool allows you to calculate insights about board's data by filtering, grouping and aggregating columns. For example, you can get the total number of items in a board, the number of items in each status, the number of items in each column, etc. Use this tool when you need to get a summary of the board's data, for example, you want to know the total number of items in a board, the number of items in each status, the number of items in each column, etc.[REQUIRED PRECONDITION]: Before using this tool, if new columns were added to the board or if you are not familiar with the board's structure (column IDs, column types, status labels, etc.), first use get_board_info to understand the board metadata. This is essential for constructing proper filters and knowing which columns are available.[IMPORTANT]: For some columns, human-friendly label is returned inside 'LABEL_<column_id' field. E.g. for column with id 'status_123' the label is returned inside 'LABEL_status_123' field.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| boardId | Yes | The id of the board to get insights for | |
| aggregations | No | The aggregations to get. Before sending the aggregations, read guidelines.aggregation from get_column_type_info with fetchMode "guidelines" for a relevant column type on this board. Transformative functions and plain columns (no function) must be in group by. | |
| groupBy | No | The columns to group by. All columns in the group by must be in the aggregations as well without a function. | |
| limit | No | The limit of the results | |
| filters | No | The configuration of filters to apply on the items. Use get_board_info for column ids and types on the board. Before sending the filters, use get_column_type_info with fetchMode "guidelines" and use data.guidelines.filter (null if that type has no documented rules). | |
| filtersOperator | No | The operator to use for the filters | and |
| orderBy | No | The columns to order by, will control the order of the items in the response |