2 Replies Latest reply on Mar 1, 2013 1:04 PM by Geoffrey Engelstein

    Overlaying spark charts

    Geoffrey Engelstein

      I've got a database table that records our daily sales. Two columns:

       

      SalesDate

      SalesDollars

       

      I use this to generate a daily Dashboard report that shows a spark chart of our sales for the last 12 months. Works great, everyone loves it.

       

      Someone requested that I overlay the last 12 months and the prior 12 months as two spark charts on the same graph, so we can see trends and seasonality. So for example, today's chart would show data from 3/1/2012 - 2/28/2013 and 3/1/2011 - 2/28/2012 overlaid on each other.

       

      Ideally I'd like to be able to do three or more, as we have data back to 2009, but for now two lines will do.

       

      So far I have been stumped at how to do this.  Any suggestions?

       

      Geoff