Using calculated fields, you can perform these actions within the same sheet.
There are many different ways to do this, but here's A solution (there may be better ones out there):
IF [Data Field] < TODAY() and [Date Field] > DATEADD('year',-1,TODAY()) THEN [Measure] END
IF [Date Field] > DATEADD('year',-1,TODAY()) and [Date Field] > DATEADD('year',-2,TODAY()) THEN [Measure] END
Third (% change. this is just simple arithmetic, you can do the math for the difference):
[First Calc] - [Second Calc]
Hope this helps!
Thanks for your quick reply. Unfortunately, I've already tried that and it didn't seem to work. With that method, both the calculated fields are converted to attributes (i.e. ATTR(Current Period Calc) and ATTR(Previous Period Calc)). These two numbers are actually the same unless I filter the dates in the filter shelf, but of course the problem with that is I'm not able to filter by two periods on the same sheet.
Also, when I tried to subtract or divide these two calculations via a third calculated field, Tableau does not yield any numbers.
Hello Aiden, were you able to resolve this issue? I am trying to achieve kind of similar functionality.