Kibana datatable visualization to use multiple saved searches for different column

Elastic Stack Kibana
1

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?

1 Like
2

What do you mean by merge the two tables together? Can you show an example?

2 Likes
3

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
formatted-table-21893×433 111 KB

1 Like
4

Hi Archana,
I have provided an example above. Any suggestions?

5

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