I am doing a search and evaluating count, avg RT based on some URL patterns. Below are the URLs for my category pages :
//Food/Back-to-School/Breakfast/Breakfast-Bars/c/1015001004
//Food/Back-to-School/Breakfast/Cereal/c/1015001001
//Home-%26-Lifestyle/Beauty/Cosmetics/Eyes/c/2004001001
Using below query gives me the different results for different URLs, but I want results grouped into 1 Relative URL.
sourcetype=apache:access request_uri="\*/c/\*" | search apache_responsetime=* | chart perc90(apache_responsetime) over request_uri
What query I should use to get desired results?
... View more