title: How to zero-fill charts/bins in Application Insights Analytics
body: <p>I'm trying to plot an area chart of one sum/count metric over time in Application Insights Analytics:</p>
  
  <pre><code>customEvents
  | where timestamp &gt; ago(7d)
  | summarize count() by bin(timestamp, 1h)
  | render areachart  
  </code></pre>
  
  <p>What I see is that if there is no data in some buckets then chart doesn't drop to 0. Instead two dots are connected and there is perception that there were some data when in fact there were not.</p>
  
  <p>Question - how to get zero-filled area charts (corresponding to red ink chart)?</p>
  
  <p><a href="https://i.stack.imgur.com/yKcIi.png" rel="noreferrer"><img src="https://i.stack.imgur.com/yKcIi.png" alt="enter image description here"></a></p>