I've created a visualization to show metrics like Total requests, Unique Tests(unique count of test field), Tests failed (Sum bucket with filter for failed tests unique count), Test passed(Sum bucket with filter for passed tests unique count). Here I want to show Tests passed and failed based on the latest execution result of test.
For eg: In first request, if I ran 10 tests and i got 6 pass and 4 fail and in second request, same 10 tests are reran, I got 8 pass and 2 failed. Now the dashboard shows these values
Total requests - 2, Unique tests -10, Tests passed - 8, Test failed - 4 (passed + failed = 12 not correct)
But I expect the output to be
Total requests - 2, Unique tests -10, Tests passed - 8, Test failed - 2
Is there an option to achieve this in Kibana? Any help will be really helpful