Hi,

I wonder if anyone can help me to draw a survival plot in Kibana. Survival plots are a well known way of displaying the survival of a population over time (wikipedia ) and I have the data to do it but can't work it out in Elastic/Kibana.

My index is made up of many person documents each with a person ID and survival number of days integer (plus other attributes we don't care about right now).

{"person_id": "aaa111",

"survival_days": 5 }

{"person_id": "aaa112",

"survival_days": 42 }

{"person_id": "baa101",

"survival_days": 1 }

{"person_id": "daa811",

"survival_days": 682 }...

A histogram can be drawn from this data just by pointing the line chart at the data., i.e. count of people vs survival days. The population gradually dies off at a steady rate. A survival plot is a different view made by plotting the sum of remaining people at every day such that on day 1 everyone is alive so it reads 100%, day two some have died off and the remaining sum is plotted as a percentage. This is repeated every day that someone dies off resulting in a gradually descending curve where the percentage total still alive decreases.

One way of thinking about it is from the simple histogram of spread of people vs survival days, every bar is replaced by a point which is the sum of all the bars (population) to the right of it.

As this seems to be some kind of aggregation, or set of aggregations, I would think elastic should be able to do it. Can anyone work it out?