# Kibana datatable visualization to use multiple saved searches for different column **URL:** \ **Category:** Kibana\ **Created:** [June 21, 2018, 2:38pm UTC](https://discuss.elastic.co/t/kibana-datatable-visualization-to-use-multiple-saved-searches-for-different-column/136896 "2018-06-21T14:38:49Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![chetang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chetang/32/3451_2.png) [@chetang](https://discuss.elastic.co/u/chetang)\ **Post date:** [June 21, 2018, 2:38pm UTC](https://discuss.elastic.co/t/kibana-datatable-visualization-to-use-multiple-saved-searches-for-different-column/136896/1 "2018-06-21T14:38:49Z")
Hello, I am trying to merge couple of data table visualizations into one. Both the data table uses different saved searches on an index. One data table analyzes the current data-set available for sell, whereas the other analyzes the older data-set from the same index (identified by time stamp and few other attributes). We are grouping data in both the tables using the same attributes of the ES document. I would like to merge both the tables together using those common attributes in both the data-tables. How can I do that? ---
**Author:** ![a5a](https://avatars.discourse-cdn.com/v4/letter/a/a87d85/32.png) [@a5a](https://discuss.elastic.co/u/a5a)\ **Post date:** [June 21, 2018, 8:51pm UTC](https://discuss.elastic.co/t/kibana-datatable-visualization-to-use-multiple-saved-searches-for-different-column/136896/2 "2018-06-21T20:51:39Z")
What do you mean by merge the two tables together? Can you show an example? ---
**Author:** ![chetang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chetang/32/3451_2.png) [@chetang](https://discuss.elastic.co/u/chetang)\ **Post date:** [June 22, 2018, 8:44am UTC](https://discuss.elastic.co/t/kibana-datatable-visualization-to-use-multiple-saved-searches-for-different-column/136896/3 "2018-06-22T08:44:39Z")
> [@chetang](#): > > Both the data table uses different saved searches on an index. One data table analyzes the current data-set available for sell, whereas the other analyzes the older data-set from the same index (identified by time stamp and few other attributes). We are grouping data in both the tables using the same attributes of the ES document. I would like to merge both the tables together using those common attributes in both the data-tables. Hi Archana, This is a simplified version of what we are trying to achieve. We have a single index which stores price of items and date of sale. e.g. ItemID | CatID | Price | DateOfSale 1 | A | 1000 | 1-Jun-2018 2 | A | 1100 | 20-May-2018 3 | B | 1200 | 15-May-2018 4 | B | 2000 | No Date (Unsold) 5 | B | 1000 | 5-May-2018 We have created a Saved Search that returns all Sold Items. We have then created a Data Table Visualization that returns the average price of each Category. e.g. CatID | Average Price A | 1050 B | 1100 We have create another Saved Search that returned Items Sold in May 2018. We have then created another Data Table Visualization that returns the total sales per Category in May 2018 CatID | NumSalesMay2018 A | 1 B | 2 We need a visualization that combines this data. e.g. CatID | Average Price | NumSalesMay2018 A | 1050 | 1 B | 1100 | 2 ![formatted-table-2](https://us1.discourse-cdn.com/elastic/original/3X/4/5/455c76b89e95c5a7dc119513d4a5e86959fbc08e.jpg) ---
**Author:** ![chetang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chetang/32/3451_2.png) [@chetang](https://discuss.elastic.co/u/chetang)\ **Post date:** [June 27, 2018, 11:09am UTC](https://discuss.elastic.co/t/kibana-datatable-visualization-to-use-multiple-saved-searches-for-different-column/136896/4 "2018-06-27T11:09:14Z")
Hi Archana, I have provided an example above. Any suggestions? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 25, 2018, 11:09am UTC](https://discuss.elastic.co/t/kibana-datatable-visualization-to-use-multiple-saved-searches-for-different-column/136896/5 "2018-07-25T11:09:16Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.