title: Elastic Search count between dates
body: <p>I have elastic search and kibana version 7.X </p>
  
  <p>I have a document with date fields:</p>
  
  <ol>
  <li>start_date</li>
  <li>end_date</li>
  <li>created_at</li>
  </ol>
  
  <p>I wanted to get the number of people I have in my database by month --> A line chart with x-axis date histogram and count on y-axis did the trick. </p>
  
  <p>Now I would like to have the number of active people by month. An active person is one where the current date is between the start and end date. I can't seem to know how to proceed here and apply the appropriate filters</p>
  
  <p>Is this possible with Kibana?</p>
  
  <hr>
  
  <p>I was able to find a partial solution by using filters. But here I create the values manually and hardcode the ranges. Any way to automate this?</p>
  
  <p><a href="https://i.stack.imgur.com/QZBHf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QZBHf.png" alt="enter image description here"></a></p>