Thanks @wylie that is useful to know, it does solve some of the problem. I phrased the original question wrong slightly, the filter im looking to use is a date range, the whole query is this,
% of tickets that have an invalid review field
a ticket is invalid if it,
is older than 30 days and does not have a review field
or
has a review field where the date is not greater than todays date
So the filter i need is to check if it has the field and if the value of the field is greater than todays date.
TSVB filter ratio started using KQL instead of Lucene in 7.10, and this would let you use datemath like date > now. Another option is to add a runtime field in 7.12 (or scripted field in older versions) which will set a field on each document based on your criteria, but this only works with KQL- Lucene doesn't work with these script-based fields.
Your only option without upgrading is to use Vega. Vega has been fully supported since 7.10, but was much harder to use in 7.9 due to the lack of inspector and older versions. We still have docs for 7.9 Vega which you can use, but upgrading will make it easier.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.