title: Azure Kusto time series
body: <p>We are having some trouble using the time charts in Azure Kusto.
  In this chart we have grouped http exceptions over time.</p>
  <p>The issue is that the chart still reports the last seen value for points in time where that exception does not exist.
  See red markings.
  In this specific case we see that the chart reports 3.23k exceptions on the /poll endpoint at 5:28. while there are in fact no such error at that time.</p>
  <p><a href="https://i.stack.imgur.com/Y3ngu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Y3ngu.png" alt="enter image description here" /></a></p>
  <p>The query looks like this</p>
  <pre><code>AppServiceHTTPLogs
  | where TimeGenerated &gt; ago(1d)
  | where ScStatus &gt;= 500
  | summarize count() by tostring(CsUriStem), bin(TimeGenerated, 30m)
  | render timechart
  </code></pre>
  <p>Using a column chart makes the issue go away, but this comes with the price of being much less clear.
  Are there any other options?</p>
  <p>Can we somehow make missing values default to 0 instead?</p>