Hello everyone! I could not figure out period over period calculations since I am pretty new.

Here is my dataset:

Basically value equals to numerator/denominator for percentage metrics but for decimals it directly passes. So it gets complicated for me to create a WoW column for both percentage and decimal metrics.

For date part I have created final_report_date column from SQL by getting first date of the week. So my dates are only showing the first day of the week.

For month part I have created something like this , same applies for numerator and I have to create the same for one month before and it takes to much time. Also I could not extract weeks.

SUMIF(denominator, {report_months} =extract(‘MM’,adddatetime(-1,‘MM’,NOW())) and {report_years}=extract(‘YYYY’,adddatetime(-1,‘MM’,NOW())) )

And here is the final view that I want to create: