# Visualization complex
**URL:** https://discuss.elastic.co/t/visualization-complex/169790
**Category:** Kibana
**Created:** [February 25, 2019, 9:44am UTC](https://discuss.elastic.co/t/visualization-complex/169790 "2019-02-25T09:44:39Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@sysdradmin](https://discuss.elastic.co/u/sysdradmin)
#### Post date: [February 25, 2019, 9:44am UTC](https://discuss.elastic.co/t/visualization-complex/169790/1 "2019-02-25T09:44:39Z")
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
---
### Author:  [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [February 25, 2019, 11:41pm UTC](https://discuss.elastic.co/t/visualization-complex/169790/2 "2019-02-25T23:41:05Z")
Elasticsearch can't do joins, so the general recommendation here would be to denormalize your data when indexing it in ES if possible.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 25, 2019, 11:41pm UTC](https://discuss.elastic.co/t/visualization-complex/169790/3 "2019-03-25T23:41:07Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.