1 Reply Latest reply on Jan 16, 2012 3:56 PM by Dimitri.B

    Plotting failure rates using date functions

      I believe this is a date function problem. The overall goal I am trying to achieve is to plot which product lines are having the most trouble with failures. The calculations will need to be a moving calculation as well.  My first failure rate is on the x axis and is the yearly failure rate( I currently have the yearly date in 'columns' and have 2011 year visible). The second failure rate is plotted on the y axis and is the failure rate for the past 2 months.  I can't figure out the function to show the 2 months. The current result I have is x axis= yearly rate  and y axis= yearly rate.

       

      Any help would be greatly appreciated!

      Thanks!