3 Replies Latest reply on Feb 20, 2013 4:39 PM by mingng1

    Graph rolling previous 30 days, and also same 30 days period year over year on same chart

    mingng1

      I want to create a combination chart which is a rolling previous 30 days value of visits (in bar) and also for the same 30 days of previous year, show  the value in a line graph.

       

      I hacked a version using a datediff to create an date-offset-1year value, to visualize what I'm looking for, but I can't get it to do a rolling 30 days back since it's rolling 30 days from current date and rolling 30days from same day a year ago.  I'd like the rolling 30 days to be always 30 days from current date.

       

      If someone knows how to do this before and can share how, that would be great.

       

      workbook attached.

       

      Thanks.