# Doing visualization from multiple documents
**URL:** https://discuss.elastic.co/t/doing-visualization-from-multiple-documents/113712
**Category:** Kibana
**Created:** [January 2, 2018, 2:48am UTC](https://discuss.elastic.co/t/doing-visualization-from-multiple-documents/113712 "2018-01-02T02:48:28Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Harsh\_Verma](https://discuss.elastic.co/u/Harsh_Verma)
#### Post date: [January 2, 2018, 2:48am UTC](https://discuss.elastic.co/t/doing-visualization-from-multiple-documents/113712/1 "2018-01-02T02:48:28Z")
I have an index with documents having structure like
> ```
> {
> department:department_value,
> employee_id:id_value
> }
> and some more documents with structure like
> {
> age:42,
> tags:[
> {key:employee_id, value:id_value}
> ]
> }
>
> ```
if I wanted to combine the data from these two documents in my visualization based on employee\_id, is there any way to do that in Kibana, or can I write a Elasticsearch query in Kibana for something like this? Or is there any visualization tool apart from Kibana for Elasticsearch that can support this?
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [January 2, 2018, 3:02am UTC](https://discuss.elastic.co/t/doing-visualization-from-multiple-documents/113712/2 "2018-01-02T03:02:13Z")
That's a join which Kibana or Elasticsearch cannot handle.
You would be best off normalising/joining things before sending them for indexing.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 30, 2018, 3:02am UTC](https://discuss.elastic.co/t/doing-visualization-from-multiple-documents/113712/3 "2018-01-30T03:02:24Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.