<p dir="auto">I used time series line chart to display the data trending, but the value was shifted by 1 day, e.g. the value on 2016-05-01 was 23801, but actually the value was plotted on 2016-04-30. Will you help to investigate it or give some suggestions. Thanks a lot.</p>
<p dir="auto">the data exported by caravel:<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://cloud.githubusercontent.com/assets/1047330/17760267/249bf15c-6531-11e6-91ca-a20383f593d9.png"><img src="https://cloud.githubusercontent.com/assets/1047330/17760267/249bf15c-6531-11e6-91ca-a20383f593d9.png" alt="image" style="max-width: 100%;"></a></p>
<p dir="auto">the plot actually made by caravel:<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://cloud.githubusercontent.com/assets/1047330/17760285/4c999c40-6531-11e6-8cc7-18e4f666fbe2.png"><img src="https://cloud.githubusercontent.com/assets/1047330/17760285/4c999c40-6531-11e6-8cc7-18e4f666fbe2.png" alt="image" style="max-width: 100%;"></a></p>
<p dir="auto">It looks like there's an off by one in the month visualization. If i do this kind of query:</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="select foo, COUNT(distinct bar) from baz and EXTRACT(month FROM &quot;date&quot;) =2 and EXTRACT(year FROM &quot;date&quot;) = 2015 group by foobar;"><pre class="notranslate"><code class="notranslate">select foo, COUNT(distinct bar) from baz and EXTRACT(month FROM "date") =2 and EXTRACT(year FROM "date") = 2015 group by foobar;
</code></pre></div>
<p dir="auto">I see the count numbers to match the "2015-01" column while i expect it to be "2015-02" instead. If i export the csv i see data correctly with a "2015-02-01" timestamp.</p>
<p dir="auto">Reproduced both in 0.9.1 and 0.10.0.</p>