# Is there any way to count two similar elements together in kibana visualization?

**URL:** https://discuss.elastic.co/t/is-there-any-way-to-count-two-similar-elements-together-in-kibana-visualization/242118
**Category:** Kibana
**Created:** [July 22, 2020, 12:37am UTC](https://discuss.elastic.co/t/is-there-any-way-to-count-two-similar-elements-together-in-kibana-visualization/242118 "2020-07-22T00:37:22Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![myohyun](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/myohyun/32/58071_2.png) [@myohyun](https://discuss.elastic.co/u/myohyun)
#### Post date: [July 22, 2020, 12:37am UTC](https://discuss.elastic.co/t/is-there-any-way-to-count-two-similar-elements-together-in-kibana-visualization/242118/1 "2020-07-22T00:37:22Z")

</div>

Hi,

I'm curious if similar elements in the field are counted together in kibana visualization, like:

In the field "request" there are two kinds of values

```auto
- "discuss.elastic.co/c/elastic-stack/kibana/7" (count: 10)
- "discuss.elastic.co/c/elastic-stack/kibana/7?" (count : 10)

```

I wanna aggregate these two values together in kibana table visualization  
with value name

```auto
 "discuss.elastic.co/c/elastic-stack/kibana/7" (count: 20)

```

 ![kibana_table_prob](https://us1.discourse-cdn.com/elastic/original/3X/1/0/101a054b8a8fb81ae3f4ded7a2bebfee34a2f67d.jpeg)

Is it possible?

Thank you 🙂

---

<div class="post-metadata">

### Author: ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)
#### Post date: [July 22, 2020, 1:09am UTC](https://discuss.elastic.co/t/is-there-any-way-to-count-two-similar-elements-together-in-kibana-visualization/242118/2 "2020-07-22T01:09:09Z")

</div>

You can for sure in Vega.

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [July 22, 2020, 1:15am UTC](https://discuss.elastic.co/t/is-there-any-way-to-count-two-similar-elements-together-in-kibana-visualization/242118/3 "2020-07-22T01:15:50Z")

</div>

You should be able to do this with a filter, on a standard visualisation, as well.

---

<div class="post-metadata">

### Author: ![myohyun](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/myohyun/32/58071_2.png) [@myohyun](https://discuss.elastic.co/u/myohyun)
#### Post date: [July 23, 2020, 1:48am UTC](https://discuss.elastic.co/t/is-there-any-way-to-count-two-similar-elements-together-in-kibana-visualization/242118/4 "2020-07-23T01:48:04Z")

</div>

I tried to use a filter on a table visualization , and my query seems to be something wrong.  
It always count all requests ignoring the filter.

What is wrong..? could you help me?

This picture shows all kinds of requests in the index and total count is **67677**

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/8/d836c2baf812c96756e5148e7e55247260c253a2.png)

and I applied a filter query catching requests including **"/data\_lake/api/v1/market\_category/matching\_result"**  
on a json input and total count is same as first one.  
(correct result is **67667** )

```auto
total 67667
/data_lake/api/v1/market_category/matching_result : 67663
/data_lake/api/v1/market_category/matching_result?api_key=airnd : 4

```

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/6/26d24d2b40d392313332fd2104222078799ebd80.png)

```auto
{
        "filters" : {
          "request1" : { 
            "query_string" : { 
              "query":
                "request : /(//data_lake//api//v1//market_category//matching_result).*/"   
              
            }
          }
        }
      }

```

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/c/9c4675af65f042e171b3c051be95d010aff30e98.png)

---

<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: [August 20, 2020, 1:48am UTC](https://discuss.elastic.co/t/is-there-any-way-to-count-two-similar-elements-together-in-kibana-visualization/242118/5 "2020-08-20T01:48:07Z")

</div>

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