How to combine url string field in kibana bar chart visualization?

Elastic Stack Kibana
1

using apm I have collected my application logs and there I found url data like

abc.com/edit/1
abc.com/edit/2
abc.com/edit/3

abc.com/update/1
abc.com/update/3
abc.com/update/5

what I am trying to do is I want to plot number of total update vs total edit operation calls. But when I am creating bar chart, it treats abc.com/update/1
abc.com/update/3...as different line. How can I calculate abc.com/update/* vs
abc.com/edit/* ?
I selected Terms>url.path and there is no other option to provide additional formatting. This might be a very easy problem but I am new to elastic and kibana so please accept my apology.

2

It sounds like your indexed data isn't in the shape you want it to be for analysis, but it's close. You can either index the data in the shape you want for analysis, or you can extract the relevant pieces at runtime by creating a "scripted field" in your Kibana index pattern using the Painless scripting language.

Indexing the data in the right shape for analysis is the preferred method, and you could use ingest pipelines to do this