0 Replies Latest reply: Jul 31, 2012 1:56 PM by jhoffef15 RSS

    Date Field that plots years on top of each other.

      Hello,

       

      I have a date feild that takes snapshots of our KPIs for comparison. We look at these KPIs by sales year and I am looking to plot these snapshots on top of each other so we can compare like dates by sales year. We capture mondays by snapshot so dates in 2011 will not nessarity equal those in 2012. So far I have tried to make a calculated demension , but it has not worked....I am still seeing two lines (for each year) not on top of each other. Here is the code.

       

      =Aggr(Date(SnapshotDate_ReportingDate,'MM-DD'),SnapshotDate_ReportingDate)

       

      Any help is appreciated!

       

      Thanks!

      Jeff