My team and I are very new to Kibana and elasticsearch, but we started using them for error reporting as well as automated test reporting.
What I'm having trouble with is getting a chart that accurately represents the last known status for our test cases.
I have data that is being sent in from the automation software, which get serialized into strings (despite whatever data-type they start as). The important values are the names of the scenarios (Scenario A, Scenario B, Scenario C, etc.) and their last reported status (pass, fail, error, and so on). I only want each scenario to be represented once in my chart and I want them to be sorted into buckets by their last statuses.
The closest I've gotten is something like this:
This is supposed to represent 80 scenarios, but the data is counting 81 because of one scenario which errored the first time it was run and then failed (correctly) the second time (and every time after).
How do I get this graph to only recognize the last record for each scenario?
- Aggregation = Unique Count
- Field = scenario name "keyword"
- Aggregation = Terms
- Field = scenario status "keyword"
- Order By = metric: scenario name
- Order = Descend
- Size = 4 (number of possible statuses)
Looks like this post is trying to do exactly the same thing.
I think what I want is to use the "Top Hit" aggregation in the metric, but regardless of which field I target, I don't get any options in the "Aggregate with" drop-down, which is a required field. This seems like a bug to me but if there are any other suggestions for this, that would be great as well.