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

    giles.somers.1

      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?

       

      Thanks

      Giles