# Filter Values in Different Streams and Group Them in Data Table

**URL:** <https://discuss.elastic.co/t/filter-values-in-different-streams-and-group-them-in-data-table/301742>\
**Category:** Kibana\
**Created:** [April 6, 2022, 10:59am UTC](https://discuss.elastic.co/t/filter-values-in-different-streams-and-group-them-in-data-table/301742 "2022-04-06T10:59:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![\_PA](https://avatars.discourse-cdn.com/v4/letter/_/90ced4/32.png) [@\_PA](https://discuss.elastic.co/u/_PA)\
**Post date:** [April 6, 2022, 10:59am UTC](https://discuss.elastic.co/t/filter-values-in-different-streams-and-group-them-in-data-table/301742/1 "2022-04-06T10:59:02Z")

</div>

I am running ELK 7 and I have the following scenario.

I have data in one index that looks like this:

|Time|ID|AAA|  
|Apr 6, 2022 @ 11:48:11.197|300965890|tar1|  
|Apr 6, 2022 @ 11:48:11.196|300965890|add3|  
|Apr 6, 2022 @ 11:48:11.195|300965890|add4|  
|Apr 6, 2022 @ 11:48:11.194|300965888|tar1|  
|Apr 6, 2022 @ 11:48:11.193|300965888|add2|

![iiii](https://us1.discourse-cdn.com/elastic/original/3X/a/2/a26ffb2ce85deefddba29688c354e1acaa5c49ae.png)

I want to make a data table that has the following structure

|AAA|# ID|  
|tar1|2|  
|add2|1|  
|add3|1|  
|add4|1|  
|tar 1 & add3|1|  
|tar1 & add4|1|  
|tar 1 & add2|1|

![dddddd](https://us1.discourse-cdn.com/elastic/original/3X/6/1/6145e935f2790c87b54a5ab1593001efe726d9e5.png)

I am having difficulty in making the rows where there is a combination of tar & add.

I used a breakdown by Filters and I have the following metrics (I chose the unique count).  
 ![sssss](https://us1.discourse-cdn.com/elastic/original/3X/f/c/fcd8d857d692fb8264d903a95ead8b1f1be6827a.png)

Can you help me?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 4, 2022, 10:59am UTC](https://discuss.elastic.co/t/filter-values-in-different-streams-and-group-them-in-data-table/301742/2 "2022-05-04T10:59:16Z")

</div>

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