How to filter a table based on another table's contents

Elastic Stack Kibana
1

Hello, I am using Kibana 7.10 and am trying to find a way to visualize the relationship that is between two tables of data I have.

Table 1 is similar to:
+-------------+-------------+------------+---------------+------------------------+
| X-Coord | Y-Coord | Owner | Date | Location ID |
+-------------+-------------+------------+----------------+------------------------+
| 2345.42 | 123.87 | Name 1 | 3/3/2022 | 975849372920 |
+-------------+-------------+------------+----------------+-------------------------+
| 128.87 | 6742.43 | Name 2 | 4/6/2019 | 647835423054 |
+------------+-------------+-------------+----------------+-------------------------+
| 123.87 | 2345.42 | Name 2 | 11/5/2018 | 589835423054 |
+------------+-------------+-------------+----------------+-------------------------+

Table 2 is similar to:
+---------------------------+-------------------+-----------------------+
| Note | Note ID | Location ID |
+---------------------------+-------------------+-----------------------+
| Location one is.... | 1233213232 | 975849372920 |
+--------------------------+--------------------+-----------------------+
| Location two is... | 5435436346 | 647835423054 |
+--------------------------+--------------------+-----------------------+
| Location two is... | 7198273543 | 647835423054 |
+--------------------------+--------------------+-----------------------+
| Location three is... | 2134558493 | 589835423054 |
+--------------------------+--------------------+-----------------------+

I am looking for a way to filter the first table on "Owner" and then the second table on my dashboard would filter down to only show the columns where "Location ID" was the same between the two tables.

For example if I was to filter where "Owner" was "Name 2" then in the second table only the columns with Location ID "647835423054" and "589835423054" present would show.

2

You may create index pattern for each dataset. Management-> index pattern

Add Two Data Table Visualizations:
Click on "Add" and select "Data Table" visualization. Then, choose the respective index patterns you created for each table.

For the first data table visualization, you want to filter based on the "Owner" field. In the "Metrics & Axes" tab, select "Filters" under the "Buckets" section. Click "Add" and set up the filter to include only documents where "Owner" is "Name 2".

For the second data table visualization, you want to show the "Location ID" field and group data by it. In the "Metrics & Axes" tab, select "Terms" under the "Buckets" section. Choose the "Location ID" field from the dropdown.

To link the filters between the two visualizations, click on the "Options" tab of the first data table visualization and enable "Sync Filters" with the second visualization.

And hit save button.

3

For the first data table visualization, you want to filter based on the "Owner" field. In the "Metrics & Axes" tab, select "Filters" under the "Buckets" section. Click "Add" and set up the filter to include only documents where "Owner" is "Name 2".

Would this work only for documents where "Owner" is "Name 2" or would I be able to make it change it where if I was to filter the dashboard on "Name 1" it would show me associated "Location ID"s on the second table?

4

Where exactly are you seeing "Sync Filters"?

Under the options tab in the Data Table I am only seeing "Show metrics for every bucket/level",
"Show partial rows", and "Show total".

5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.