# URL Reformatting in Kibana Visualization
**URL:** https://discuss.elastic.co/t/url-reformatting-in-kibana-visualization/243236
**Category:** Kibana
**Created:** [July 30, 2020, 2:11pm UTC](https://discuss.elastic.co/t/url-reformatting-in-kibana-visualization/243236 "2020-07-30T14:11:44Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@stellarwinds1](https://discuss.elastic.co/u/stellarwinds1)
#### Post date: [July 30, 2020, 2:11pm UTC](https://discuss.elastic.co/t/url-reformatting-in-kibana-visualization/243236/1 "2020-07-30T14:11:45Z")
Hi, In our logs we have the API being captured as something like GET:/xxx/yyy/carts/c3ui34u/status and GET:/xxx/yyy/carts/3j32j4l/status etc. i.e. the specific cartID is part of the API.
So, while doing the aggregations, each of the above is coming with a count of 1. Is there anyway (as part of visualization query), I can rename those API URLs to something as simple as GET:/xxx/yyy/carts/{id}/status, so that each of the above entries will be replaced with this generic entry, so that I will get the total count per day of ALL those cart status calls? I tried to use the setting -\> Kibana -\> Index Patterns -\> URL format, but I was not successful (probably that is not the way to do it - may be).
Please note that I am not looking for a change in the source itself, but if there is anyway I can do this translation AS PART OF running a query to print the aggregates.
Any help is appreciated.
Thanks,
---
### Author:  [@tjfred](https://discuss.elastic.co/u/tjfred)
#### Post date: [July 30, 2020, 2:27pm UTC](https://discuss.elastic.co/t/url-reformatting-in-kibana-visualization/243236/2 "2020-07-30T14:27:22Z")
You may need to split the log up into the relevant fields at indexing time, I'm not sure you'll be able to achieve what you want with a visualization query.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 27, 2020, 2:27pm UTC](https://discuss.elastic.co/t/url-reformatting-in-kibana-visualization/243236/3 "2020-08-27T14:27:22Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.