Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Apprently posting the question is further impetus to not stop thinking about it.
I used a calculated dimension and concatenated the month and day:
=Month(Date) & Day(Date)
Less readable for my users (but still solving my original issue) would be to use the calculated dimension:
=DayNumberOfYear(Date)
Apprently posting the question is further impetus to not stop thinking about it.
I used a calculated dimension and concatenated the month and day:
=Month(Date) & Day(Date)
Less readable for my users (but still solving my original issue) would be to use the calculated dimension:
=DayNumberOfYear(Date)