Is it possible to compare data of 2 different date ranges using one starting point?
I have a client that has data similar to this:
date
Store1 sales
9/1/2013
121.25
9/2/2013
113.77
9/3/2013
150.20
9/4/2013
138.01
10/1/2013
111.44
10/2/2013
122.11
10/3/2013
135.68
What they want to be able to do is select the date ranges 9/1/2013 - 9/4/2103 in one listbox, and the range 10/1/2013 - 10/3/2013 in another, and have a line chart drawn with two lines representing the daily Store Sales over the two date ranges respectively, but with both lines starting at the same point on the x-asis. In other words, the data points for 9/1/2013 and 10/1/2013 line up at the first point, 9/2 and 10/2 line up at the second and so on.
An additional requirement is that the date ranges need not start at the same day of the month; in other words, they can be completely arbitrary ranges both in start and length.
Create fields Day using function day(Date) and Month, using function Month(Date).
Use both as chart expressions, so the Day is on the X-axes. Sales will be in your expression. In a line, you'll get one line per Month. You can select any Day range you want.
