I am trying to calculate consistently failing tests over the past 48 hours. For my index I have test results with two significant fields:
test_identifier (string) and
test_result_status (pass or fail).
I would like to display the count of tests that have passed and not failed, and also the list.
Using the Dev Tools Console I can create an Elasticsearch query to accomplish this. I am able to create filter aggregations to count the total pass and total fail, and use a bucket_selector script like this:
params.pass_count == 0 && params.fail_count > 1. This results in buckets for each test that fails so I have the list and the count of consistently failing tests.
However, I am not able to visualize this bucket list or count. I cannot get the Metric and TSVB visualizations to accomplish this. How can I get this ElasticSearch result displayed in a Metric or other visualization?