title: amazon quicksights compare time periods
body: <p>Can line charts or bar charts compare two time periods?<br>
  Example compare sales revenue between 2017 to 2016 by month, to see how Jan 2017 compares to Jan 2016, Feb 17 to Feb 16, etc.  </p>
  
  <p>In the chart I'd like to see whether I'm up or down between the periods.
  The data can be manipulated anyway required, but simplistically  looks like this</p>
  
  <pre><code>currentDate CurrentSum  PreviousSum
  1/1/2016    1949    1917
  2/1/2016    2217    1949
  3/1/2016    2180    2217
  4/1/2016    2197    2180
  5/1/2016    2320    2197
  6/1/2016    2267    2320
  7/1/2016    2187    2267
  8/1/2016    2355    2187
  9/1/2016    2226    2355
  10/1/2016   2175    2226
  11/1/2016   2356    2175
  12/1/2016   1939    2356
  1/1/2017    2072    1939
  2/1/2017    2310    2072
  3/1/2017    2453    2310
  4/1/2017    2128    2453
  5/1/2017    2515    2128
  6/1/2017    2403    2515
  7/1/2017    1244    2403
  </code></pre>