Kibana visualization for total count of Jenkins jobs currently passing/failing

[jupp]

I had pretty much the same question two years ago. Unfortunately, I never got an answer. Perhaps there is now a solution that I do not yet know.

Count the result of an aggregation

Given then following Dataset: id @timestamp message 1 2016-05-03T16:30:39.000Z online 2 2016-05-03T16:29:39.000Z online 1 2016-05-03T15:30:39.000Z dead 3 2016-05-03T15:27:39.000Z online 4 2016-05-03T15:28:39.000Z dead 3 2016-05-03T15:25:39.000Z dead 2 2016-05-03T14:29:39.000Z dead 4 2016-05-03T14:28:39.000Z online I want to get the last Event per id and the Count how many ids are "online" or "dead" The result should be: { "key": "online" "do…

Hopefully someone else knows advice, or can say why that is not possible.