# HELP - decreasing date depending visual

**URL:** <https://discuss.elastic.co/t/help-decreasing-date-depending-visual/235987>\
**Category:** Kibana\
**Created:** [June 5, 2020, 5:06pm UTC](https://discuss.elastic.co/t/help-decreasing-date-depending-visual/235987 "2020-06-05T17:06:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![julianf19](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@julianf19](https://discuss.elastic.co/u/julianf19)\
**Post date:** [June 5, 2020, 5:06pm UTC](https://discuss.elastic.co/t/help-decreasing-date-depending-visual/235987/1 "2020-06-05T17:06:54Z")

</div>

Hi,  
I am trying to build a visualization in kibana:  
I have a set of data that have an end date or not yet (work still to be acomplished)  
I want to visualize how fast the work load is decreasing.  
Lets say i am looking at jobs that need to be done from the 1st of january till the end of april,  
if i complete a job (one data) its end date is set (lets say 1st of february), I would like that data to be taken into account left of its completion date and then not anymore.

If all jobs are done the graph goes to 0, because all data have end dates.

Basically it is a count the number of data over the period - the cumulative sum  
I am not sure i am explaining this right.

Thanks in advance for the help

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [June 23, 2020, 7:13pm UTC](https://discuss.elastic.co/t/help-decreasing-date-depending-visual/235987/2 "2020-06-23T19:13:28Z")

</div>

I think you can get something similar by using the Filters aggregation. You can have two filters:

end\_date: \*  
NOT end\_date: \*

And then compare these two filters in a date histogram. This will create two series which you can stack to get the total amount changing over time.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 21, 2020, 7:13pm UTC](https://discuss.elastic.co/t/help-decreasing-date-depending-visual/235987/3 "2020-07-21T19:13:33Z")

</div>

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