Compare to the Same Day Last Year in Tableau

Let’s say you want to compare a value from today to the same day last year to evaluate performance. Creating the calculated field for today’s value looks like this:

To compare to exactly this day (April 23rd as of this writing) last year, you would want to create something like this:

49-2.png

Here’s the result of these two calculations:

49-3.png

Let’s say your scenario is more complicated though. You want to compare to the closest comparable weekday last year. April 23rd is a Monday so we want to compare to the closest Monday in April of last year. In that case we would want a calculation like this:

49-4.png

With that calculation we ensure we are looking at data from last year, it is from the same week number as last year, and it is the same weekday as well. Here’s the result (which ends up being a much closer comparison):

49-5.png

Have an even more complicated scenario than that? It's possible. You may need to build a custom calendar and import it into Tableau as an additional data source. If you think that's the case, you can sign up for an office hour and we'll help you build and implement the data source you need.