I want to show a gauge with a value that is calculated via an aggregation, the issue is i want the aggregations to be based on a filter, such that
I have a count value that is (number of docs with attribute:A)
I have a count value that is (number of docs with attribute:B)
Currently you can only do a query that effects all calculations in the TSVB and theres not even an option to add a filter.
Is there a known work around for this?
I have read about script aggregations but not sure how to use that in TSVB.
I am using Elastic stack 7.9 and cannot upgrade due to dependencies.