The derive queries panel takes a query and a field, runs a terms facet, then creates queries based on them. For example, you might want to see a histogram of the top 5 requests that return a 404.
You should be careful not to select a high cardinality field as Elasticsearch must load all of these values into memory.
Query Mode allows to optionally append original query to each term in the list.