# How to clean & group url with paramater data
**URL:** https://discuss.elastic.co/t/how-to-clean-group-url-with-paramater-data/277000
**Category:** Kibana
**Created:** [June 25, 2021, 3:41am UTC](https://discuss.elastic.co/t/how-to-clean-group-url-with-paramater-data/277000 "2021-06-25T03:41:25Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@blukit](https://discuss.elastic.co/u/blukit)
#### Post date: [June 25, 2021, 3:41am UTC](https://discuss.elastic.co/t/how-to-clean-group-url-with-paramater-data/277000/1 "2021-06-25T03:41:25Z")
I have URL field on my log which i need to group/bucket:
Unfortunately the it has some varying data on it, such as:
[https://172.18.10.41/api/v1.0/customer/inquiry/401301018517537](https://172.18.10.41/api/v1.0/customer/inquiry/401301018517537)
[http://182.18.10.41/corp/rest/v1/01/custom/applications/502569/summary](http://182.18.10.41/corp/rest/v1/01/custom/applications/502569/summary)
how to change it into:
[https://172.18.10.41/api/v1.0/customer/inquiry/userID](https://172.18.10.41/api/v1.0/customer/inquiry/userID)
[http://182.18.10.41/corp/rest/v1/01/custom/applications/ID/summary](http://182.18.10.41/corp/rest/v1/01/custom/applications/ID/summary)
for easier aggregation?
on ELK 7.10 Basic
---
### Author:  [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)
#### Post date: [July 19, 2021, 12:45pm UTC](https://discuss.elastic.co/t/how-to-clean-group-url-with-paramater-data/277000/2 "2021-07-19T12:45:45Z")
Hi there,
you could use filters aggregation, available both for Lens and Visualize and create filters in kql like:
`url : https://172.18.10.41/api/v1.0/customer/inquiry*`
`url : http://182.18.10.41/corp/rest/v1/01/custom/applications*`.
Here's a tutorial that does similar things: [Build your first dashboard | Kibana Guide [7.13] | Elastic](https://www.elastic.co/guide/en/kibana/current/create-a-dashboard-of-panels-with-web-server-data.html#treemap)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 16, 2021, 12:45pm UTC](https://discuss.elastic.co/t/how-to-clean-group-url-with-paramater-data/277000/3 "2021-08-16T12:45:47Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.