Table visualization to compare documents in same index

Hi Team,

I have a single index in which I have multiple documents having same data structure. Basically I want to compare the two or more documents based on the application filter (or more filters) provided by the user. I can draw the graphs but facing challenge on table visualization. Could you please help on the following example:

Visualization required:

Sample data -

`

Date Application ID Value Time_Taken Count
2020-08-20 App1 1 Action1 10 25
2020-09-20 App1 2 Action1 15 30
2020-10-21 App1 3 Action1 20 20
2020-08-20 App1 1 Action1 0 0
2020-09-20 App1 2 Action2 12 30
2020-10-21 App1 3 Action2 15 25
2020-08-22 App2 1 Action1 11 20
2020-09-20 App2 2 Action1 14 25
2020-10-21 App2 3 Action1 15 19

`

Welcome to our community! :smiley:

Compare them in what manner?

Thanks Mark.

Apologies if I was not clear on the ask - somehow messed up with setting my sample data. Here is my data currently fed into elastic search:

Date Application ID Value Time_Taken Count
2020-08-20 App1 1 Action1 10 25
2020-08-20 App1 1 Action2 12 30
2020-08-20 App1 1 Action3 20 20
2020-08-22 App2 2 Action1 11 20
2020-08-22 App2 2 Action2 15 25
2020-08-22 App2 2 Action3 14 25
2020-10-21 App1 3 Action1 15 19
2020-10-21 App1 3 Action2 15 30

If you see the source data I have provided - there are two applications named App1 and App2. For these two applications, I have multiple execution on different date for which a different ID is generated like for Date : 2020-08-20 we have ID as 1, for date: 2020-08-22 I have ID as 2 and so on..

Now in my current Kibana dashboard, the user will apply the filter as - **Application : "App1" and Value : "Action1"**

Based on that I need to show the comparison of response time and transaction count for the given label - Action 1 in a single row.

In the attached image you would see, I am getting two rows currently. I want it to appear in a single row only and not in multiple rows.

Is there a way to merge them in a single row with multiple columns.

Any suggestions?