Visualization complex

Hello,
We have 2 tables from 2 index.

1er index: 'acl' and table 'name'
2eme databse :'content' and table 'desciprion'

In first database we have :

id | name |

X234 | john
d234 | paul

In 2nd database we have

ident | content
id=X234 | xxxxx
id=d234 | xxxxx
id=x234 | xxxxx

With kibana we want to do a pie chart which :

  • count where id = ident and he display in pie chart the 'name' ( john )

typically with this example the result is :

2 for john
1 for paul

and in the pie chart we display : John and paul with count 2 and 1

is it possible ?

rgds

Elasticsearch can't do joins, so the general recommendation here would be to denormalize your data when indexing it in ES if possible.

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