What I am trying to do seems simple and doable but for whatever reason i can't find a way to do it:
My data in ES is modeled like so (ignoring metadata):
What I want to is model this info in a data table visualization like so:
[Project_Name] ------- [ Failed Tests] -------- [Failed Test Percentage]
Test_Group1------------- 8--------------------------- 32%
where the Failed Tests column is the sum of all the failed tests across all builds in Test_Group1 project and Failed Test Percentage is the calculated as (sum of all failed tests from all builds in Test_group1 project / sum of total tests from all builds in Test_group1 project)
What I tried doing is creating a scripted field called Failed Test Percentage but this only calculates failure percentage per entry not as an aggregation as wanted in the table above.
Any way to do this?
I would also settle for simply adding a pie chart that shows the percentage of failed tests over total tests for a all builds in a project if this possible.
Hope this is clear,