Remove Arguments from URI in kibana visualization

I am creating a visualisation with counting total urls hits
I am able to get all urls and counts
but i am getting url with arguments as below
ur1?a=1. => count 100
url1?b=2 => count 100
what i want is url1 => count 200
i.e URL without arguments

{
  "aggs": {
    "2": {
      "terms": {
        "field": "uri.keyword",
        "order": {
          "_count": "desc"
        },
        "size": 1000000,
        "exclude": "*?*"
      }
    }
  },
  "size": 0,
  "stored_fields": [
    "*"
  ],
  "script_fields": {},
  "docvalue_fields": [
    {
      "field": "@timestamp",
      "format": "date_time"
    },
    {
      "field": "serverTimestamp",
      "format": "date_time"
    },
    {
      "field": "timestamp",
      "format": "date_time"
    }
  ],
  "_source": {
    "excludes": []
  },
  "query": {
    "bool": {
      "must": [
        {
          "query_string": {
            "query": "(verticalName: info)",
            "analyze_wildcard": true,
            "time_zone": "Asia/Calcutta"
          }
        }
      ],
      "filter": [
        {
          "range": {
            "timestamp": {
              "gte": "2022-08-12T12:28:13.493Z",
              "lte": "2022-08-13T12:28:13.493Z",
              "format": "strict_date_optional_time"
            }
          }
        }
      ],
      "should": [],
      "must_not": []
    }
  }
}

How i can use exclude option to do this

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