How to have relational connectivity between two graphs dynamically

[arun_s]

Hi

I want to make relational update between two graphs , say for example i have following data
country A population for each month
country B population for each month
country C population for each month
plotted in single graph - say Graph1 .

is it possible to create a Graph2 dynamically which can show only selected country (respect to cities ) population alone if a a specific country in Graph1 is pointed using pointer ,

ex graph1 (US,EUROPE,ASIA) -> graph2(TX,CA)

is that possible with kibana

[thomasneirynck]

hi @arun_s,

Yes, that is possible I think.

You can add two charts to a dashboard. Then, you can click on a chart element of the first chart (e.g. select the US). This will send a filter to the filter-bar in the Dashboard. Then you can see your second chart update (e.g. regions in the US).

It does depend somewhat on how your data is modeled, but similar workflows are done quite frequently on the dashboard.

You can start with following videos https://www.elastic.co/guide/en/kibana/current/getting-started.html, to see some of this in action.

[arun_s]

Hi Thomas,

i agree its possible , currently i am plotting 2 graphs

graph1 - plot with respect to population of countries
xaxis - count
yaxis - months

graph2 - plot with respect to population of cities of us
xaxis - count
yaxis - months

i am able to zoom in graph 1 US datas so changes occurring in graph2

but my question is if i select data of europe in graph 1 how it will reflect in graph 2 as it is configured for US cities, so is there a way to dynamically update cities and region in graph2 keeping xaxis and yaxis same

Thanks

[thomasneirynck]

hi @arun_s,

yeah, that's more difficult.

How is your data modeled? If every document has both a region and a country-field, then it will work as described.

You would have one chart that aggregates on the country-field, and another that aggregates on the region-field. Selecting a country in the first chart, will update everything in the second chart.

To avoid clashes with identically named regions across different countries, you can use a scripted-field t hat concatenates country-name and region-name so it can serve as a unique identifier for region.