Cross Filter

Link common legends and axes across multiple charts to synchronize data display targets.

The Cross Filter feature allows you to synchronize the display targets of multiple charts when legends or axes are filtered on a specific chart.

Filtering is performed on data loaded in the frontend, so changing filters does not trigger additional job execution.

Behavior

  • Legends and axes selection status is synchronized across configured charts

    • When a legend on a chart is selected: Only data for the selected legends is displayed

    • When hovering over chart content: Highlighting of the hovered legend is synchronized

    • When selecting a range on an axis: Only data within the selected range is displayed

Configuration

  • Select Cross Filter from the menu that appears in the top-right corner when hovering over a chart on the Grid Page

  • Set a Key

    • Set the same Key for charts that you want to synchronize with the same value

    • Depending on the selected chart, you can set Keys for both "Axis" and "Legend"

      • For table charts, set a Key for each column you want to target

Specifications

  • Supported Charts

    • XY Chart

    • XYZ Chart

    • Pie Chart

    • Funnel Chart

    • Table Chart

      • Selection states from other charts are reflected in table charts, but filtering content from table charts is not reflected in other charts

  • Data Filtering Scope

    • Filtering is performed on data loaded in the frontend

    • SQL is not re-executed, so filtering data by time period on an XY chart axis cannot be reflected in pie chart aggregations

  • Legend Filtering

    • Filtering is performed based on the "string or numeric" values of the selected legend names

  • Axis Filtering

    • Range filtering is performed based on the "string or numeric" lower and upper bounds of the selected axis

Notes

  • Legend → Axis Coordination

    • Data display targets for axes are specified by range

    • Therefore, when multiple legends are selected on the legend side, not only the selected legends but also targets included in the range of the selected legends will be displayed

  • Axis → Axis Coordination

    • When axes are set as strings, range specification is affected by display order, so if display orders are different, they may not coordinate correctly

Last updated

Was this helpful?