YOY Tableau

Question

What is YOY and How to find YOY% in tableau?

Answer 1

The year-over-year growth rate calculates the percentage change during the past twelve months.

Use below code to find YOY%

(SUM([Measure]) - LOOKUP(SUM([Measure]), -1)) / (LOOKUP(SUM([Measure]), -1)) 

Add the date column and the required measure to find the YOY% for the measure.

Hope it helps!.