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:
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.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.