Cross filter Beta

Cross filter syncs the filtering state, such as legend, axis, and frame selections, between charts and query results placed on a grid page. Components that share the same key are linked together.

Filtering is applied to data already loaded on the frontend. No additional SQL job runs when a filter changes. Cross filter settings are specific to each component on the grid, and aren't synced with the chart settings on the doc page side.

INFO

This feature is in beta. The specification might change without notice.

Configuring

A chart or query result must already be placed on the grid page.

1. Hover over the target component and open Cross filter from the top-right menu.
2. If it's not yet configured, select Edit.
3. Enter a key for each item you want to link (components that share the same key are linked together).
4. Select Apply.

To remove the setting, select Clear filter from the same menu.

The items shown vary depending on the chart type and its settings. For example, a chart that doesn't use the frame feature doesn't show Frame key.

Settings

Item	Description
Legend key	Syncs whether the legend is shown or hidden. Legend names must match.
X-axis key	Syncs the X-axis display range. The axis type and content must match.
Y-axis key	Syncs the Y-axis display range. The axis type and content must match.
Frame key	Syncs the displayed frame. The frame value must match.
Data filter	Filters the table's displayed data in sync with the chart-side filtering. Add a condition using a combination of column and key.

Data filter requires you to specify the following two items.

Item	Description
Column	The target column to filter by value.
Key	The key configured on the linked chart's legend, axis, or frame.

Syncing the same field type

Setting the same key on the same type of item syncs the same operation.

Legend

• Targets: XY Chart, Radial Chart, XYZ Chart (excluding heatmap), Funnel Chart.
• Syncs legend selection, deselection, and hover highlighting.
• Links series with matching legend names.

X axis / Y axis

• X-axis key targets: XY Chart, XYZ Chart, Waterfall Chart.
• Y-axis key targets: XYZ Chart.
• Syncs axis range selection (zoom).
• The axis type (category, time, numeric, and so on) must match.
• For a category axis, filtering is based on the index range according to the data's display order.

Frame

• Targets: XY Chart, Radial Chart, XYZ Chart, Funnel Chart, Waterfall Chart, Graph Chart, Hierarchy Chart, Word Cloud.
• Only effective when the frame layout is timeline.
• The frame value must match.

Data filter

• Targets: Query result, Table Chart.
• Even between tables sharing the same key, filtering syncs based on the value of the specified column.

Syncing across different fields

Setting the same key on different types of items links them across fields.

Link	Behavior
X-axis key ↔ Y-axis key	Syncs the display range of the X axis and Y axis.
Legend key ↔ X-axis key / Y-axis key	Syncs legend and axis filtering. Only links when the axis is a category axis. If multiple legend items are selected, filters by the range from the minimum to maximum of the corresponding axis indices.
Legend key ↔ Frame key	Syncs legend and frame. Only effective for a timeline layout, and only links when a single legend item is selected.
Legend key → Data filter	Reflects legend filtering onto the table. The legend name must match the column value. There's no sync in the reverse direction from the table.
X-axis key / Y-axis key → Data filter	Reflects the axis display range onto the table. The axis value must match the column value. There's no sync in the reverse direction from the table.
Frame key → Data filter	Reflects the frame value onto the table. The frame value must match the column value. There's no sync in the reverse direction from the table.

Constraints

• Only data already loaded on the frontend is targeted. Because SQL isn't re-run, for example, narrowing an axis's period can't be reflected in a radial chart's aggregated result.
• Filtering can't be reflected from a table (query result or table chart) to other charts.
• Because linking from legend to axis works via range selection, adjacent categories between the selected legend items are also included.
• Linking between category axes (string axes) depends on display order. If the display order differs, linking won't work correctly.
• When the frame layout is grid, syncing axes and frames isn't available.