I have a combined search query using stats count and appendcols.I am able to display the combined search result in single column -multiple rows format using 'transpose'.But when I click on count value of each search result, I am able to see the log info hit result of base query only(pets who like egg).I want to see the search result of the specific query when the specific count value of search is clicked.This means when I click on "pets who like meat " count value, the search should show only those log info specific to this search only. Please guide.
The following is the query I am using:
pets who like egg | stats count AS "Total Number of Egg loving pets" | appendcols [search pets who like meat | stats count AS "Total Number of Meat loving pets"] | transpose | rename column as "Event", row* as Count*
... View more