How do I count the domain name only and not have it count by domain and query string?

I’m trying to count the domain name only. I do not want it to count the entire string because every string has the same domain name but also does not have the same query string values, so each entry is different from the other but again each has the same domain name. What is the easiest way to just count the domain but not the domain+querystring. Man, do I hope I’m making sense and clear enough to help you help me.


You’ll want to create a calculated column that extracts just the domain name from the full URL, then use that calculated column in your visual instead of the original one. You can probably extract the domain name using the split function, either splitting on / or ? depending on whether it’s the path or query string that you’re trying to strip off.

1 Like