Running Total of Living Population

Elastic Stack Kibana
1

Let's assume that I have a data set that includes a single document per person. The data will include a bornOn and diedOn field. diedOn may not have a value.

I was looking at creating a Timelion that shows me a running total of living population. I'm not super knowledgeable about Timelion, and I'm not sure how I can effectively filter per item between bornOn and diedOn based on the date being rendered.

I get that something like the following is a cumulative sum of people that ever lived, but I need to compare whether that person was actually alive based on the date being rendered:

.es(index=population, timefield=bornOn).cusum()

Any tips?

2

Hmm, I can't think of any way to accomplish this at the current time, since there is no way to access the end of the date range when creating a filter or writing a script.

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.