Alias of a created date

[Brandos]

I have averaged temperatures for days over the last 4 years (ie average temperatures for 6th June). I have done this by using:

<Day number>=DayNumberOfYear(<Date Rolling(historic temp)>)

<New Date>=RelativeDate('1/1/01' ,<Day number>)

I now want to show these results on a graph along with values from my original query, but I can't get the data to recognise the same date on the x axis. Is there a way of aliasing a dimension from my original query with a dimension I have made using a variable.

Thanks in advance for any help.