1 Reply Latest reply on Feb 6, 2014 9:56 AM by Matt Lutton

    Rolling WOW calculation

    Jeremy Thompson

      Hi All

       

      I'm fairly new to Tableau and having difficulty doing a rolling WOW comparison for some metrics..

       

      I am trying to calculate the weekly % difference for some KPIs, and I want to only show the current timeframe relative to the last week (without having to show the previous week's data).  I set up the attached chart that hides the previous weeks' data and shows the metrics for the current week vs last week... but the problem is when I change the date range this no longer works.

       

      What I want to show is dynamically calculate the current timeframe vs prior week for any time selected.