Ive got two tables of URLs, one of them counts the number of visits for the root path of a URL and the other is a list of all URLs visited. The field,
url.path, is indexed as both a text and keyword field. I would like to be able to filter by a value on the root path table and the all urls table show everything under the root path.
As an example, below is my root paths table.
I would like to be able to filter by /healthandwellness, which in turn would display the following in my all URLs table:
Right now, it doesn't work that way, because they're both looking at the keyword field. I guess the better question is, can I create a table that aggregates on a non-keyword? I realize I can use the search bar and enter
url: \/healthandwellness, but I'm trying to get this to work for non-technical users.