I have URLs of our website in our table along with some other numerical fields like visits, visitors etc.
What I want is to have a search option on my dashboard, where I can search any URL and it will show me a table containing the field for that specific URL only.
To achieve search functionality I have used wildcard match filter option(see below), and created a table in a sheet and placed it in the dashboard, but what happens is by default the table contains full data,
What I want is to have a blank table by default and when any user enters any URL, the table shows data for the respected URL only.
Thanks in advance.