I hit the following problem and feel stuck, so thanks for the help in advance.
I am indexing documents with 5 fields: id, type, country, status and timestamp.
Using graph panel I want to show the count of processed documents (status = “PROCESSED”) within the time interval. I also want to be able to filter against country and type.
I declared the variables: type and country as query type.
The problem is that country can come as null and filters are implicitly ANDed.
If I select All (default value) for “country” grafana ORs the found terms behind the scene during query construction, e.g country:FRA OR country:UK
but this way the query doesn’t take into account the documents without country.
It would seem more logical to me to treat All as ( to remove the filter completely from the generated query) but it seems that it’s not the case.
Any idea how to achieve what I want?