Linking without visualizing

[domoritz]

Moved question by Mai74D

Hi Mr. Jeffrey Heer,

I'm currently working at Aufinia Company, and we're very interested in using the Mosaic framework for our project.

We have a quick question:
We're displaying two charts using Mosaic, each powered by data from a different CSV file. Cross-filtering between the charts works well — but only when the shared key column is actually displayed on the chart (e.g., on the x or y axis).

However, in our case, we’d like to use the shared key only for linking the charts together, without needing to show it visually on either chart. Is it possible to enable cross-filtering in Mosaic using a hidden or non-displayed key?

Thank you in advance for your help — we really appreciate the work you're doing with Mosaic!

[domoritz]

Moved answer by @jheer

You can specify which column you want a 1D interval interactor (like intervalX) to filter by setting the field option to the desired column name. When unspecified, it defaults to the field(s) backing the current corresponding encoding channels (like x or y). For intervalXY you can instead use the xfield and yfield options.

Feel free to provide a more detailed example if you need more help.

[Mai74D]

Thanks for moving my question here...

[Mai74D]

@jheer

I’m now using the "field" option to add a column as a key for filtering. I can filter now, but only when the X-axis value has the same type as the key. I'm wondering if there's a way to perform filtering only based on the linking column, without filtering based on the values of the column currently being displayed.

As shown in the image below,
The column used to link the tables is named D08_ZF_KY_TEST, and it has values like 1, 2, 3, 4, 5, 6...
The values currently displayed come from the user_index column, which has values like 101, 102, 103, 104, 105, 106...

When I filter the user table, it also filters the supplier table.
However, the values being passed to the supplier table are 101, 102, 103, 104, 105, 106... instead of 1, 2, 3, 4, 5, 6... as expected.

Currently, the values I defined are:
params: brush_main: { select: crossfilter , field: D08_ZF_KY_TEST}

`- plot:

• mark: lineY
  data: { from: D08_51_RT_TOT_PER_SUPPLIER, filterBy: $brush_main }
  x: Supplier
  y: Purchase_order_value_local
  stroke: steelblue

• mark: lineY
  data: { from: D08_51_RT_TOT_PER_SUPPLIER, filterBy: $brush_main }
  x: Supplier
  y: Goods_receipt_value_local
  stroke: orange

• mark: lineY
  data: { from: D08_51_RT_TOT_PER_SUPPLIER, filterBy: $brush_main }
  x: Supplier
  y: Invoice_value_local
  stroke: green

• mark: lineY
  data: { from: D08_51_RT_TOT_PER_SUPPLIER, filterBy: $brush_main }
  x: Supplier
  y: Payment_value_local
  stroke: violet

• select: intervalX
  field: D08_ZF_KY_TEST
  as: $brush_main
  xLabel: 51-Supplier
  xLabelAnchor: center
  yLabel: Value
  height: 300
  width: 1400

• plot:

  • mark: rectY
    data: { from: D08_42_RT_TOT_PER_USER, filterBy: $brush_main }
    x: { bin: User_index }
    y: { sum: Purchase_order_value_local}
    fill: steelblue
    insetLeft: 30
    insetRight: 30
  • mark: rectY
    data: { from: D08_42_RT_TOT_PER_USER, filterBy: $brush_main }
    x: { bin: User_index }
    y: { sum: Goods_receipt_value_local }
    fill: orange
    dx: 15
    insetLeft: 30
    insetRight: 30
  • mark: rectY
    data: { from: D08_42_RT_TOT_PER_USER, filterBy: $brush_main }
    x: { bin: User_index }
    y: { sum: Invoice_value_local }
    fill: green
    dx: 30
    insetLeft: 30
    insetRight: 30
  • mark: rectY
    data: { from: D08_42_RT_TOT_PER_USER, filterBy: $brush_main }
    x: { bin: User_index }
    y: { sum: Payment_value_local }
    fill: violet
    dx: 45
    insetLeft: 30
    insetRight: 30
  • select: intervalX
    field: D08_ZF_KY_TEST
    as: $brush_main
    xLabel: 42-User
    xLabelAnchor: center
    yLabel: Value
    height: 300
    width: 1400`