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 Nov 2, 2016 10:13 AM

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

1. Re: Comparison to averages from past periods that are not shown in the view

Chris McClellan Nov 12, 2016 5:21 AM (in response to giles.somers.1)

The short answer is - you can't

The values must be in the view so you can reference them. The trick is to figure out how to have the values present in the view (so you can use them in the calculation), but not visible to the user. This is usually through a mix of measure filters, maybe using LAST() or hiding the values (ie. not excluding, but hiding).

Mock up a sample and attach it and I can show you if required.
Like Show 0 Likes(0)

Actions

Tableau Community Forums