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!
Can you post your workbook? If not, can you mock one up using Tableau's sample data?
It would be easier for others to understand what the issue is.