2 Replies Latest reply on Jun 21, 2012 9:01 AM by Eric Bokobza

    Drill up to include multiple years of data

    Eric Bokobza

      I have data for each day of the year in 2011 and 2012. I want to know if it is possible to average the data across years in a line graph. Currently, the highest level of the date hierarchy I can aggregate on is year, so it splits my data out by year. Is it possible to aggregate at a higher level (ex. decade)? Is there a "datename" function higher than year to aggregate the data on?

       

      I am using 6.0.

       

      Thanks.