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

[myohyun]

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

- "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

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

Is it possible?

Thank you

[aaron_nimocks]

You can for sure in Vega.

[warkolm (Mark Walkom)]

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

[myohyun]

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

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)

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

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