1 Reply Latest reply on Nov 12, 2016 5:21 AM by Chris McClellan

    Comparison to averages from past periods that are not shown in the view


      Hi folks


      Another day, another Tableau challenge!


      In a nutshell, I am looking to compare a last 3 months average vs an average for a past period. Let's say February to April 2015 for example.


      I have one solution that works for periods calculated from the latest ie. last 3 months vs last 12 months

      However, l'm not sure of a way to lookup averages from historical periods that are outside of the filter window.


      Ideally, I would like to show the results in a view on their own - the value for the most recent month is x difference.


      Any ideas please?