1 Reply Latest reply: Aug 8, 2012 4:46 PM by Brandon Burroughs RSS

    compare dates (M/D) from different years

      I have sales figures associated with different dates (M/D/YYYY). I'd like to get them graphed in a line graph, each year being it's own line.


      I've broken imported the dates in the script to "day" (e.g, 1, 2 ..., 31), "month" (Jan - Apr), and "year" (2008 - 2012) as well as the full "date" (i.e., M/D/YYYY). I'm comfortable aggregating dates into separate lines by using set analysis to pluck out one year per line, but I'm not sure to establish a shared x-axis.