YOY calculations - DOMO recommended formulas not working
I found this page for doing period-over-period calculations:
However, the one I really want is a YoY calculation for the same series, but when I try that formula, it comes back invalid:
DOMO YoY Calculation
Case year(`Datefield`) when year(curdate()) then 'This Year' when year(curdate())-1 then 'Last Year’ End
Updated for my data:
Case year(`FULL_DATE`) when year(curdate()) then 'This Year' when year(curdate())-1 then 'Last Year' End
Two things I noted:
1.) There is a single quote in the original formula that doesn't get recognized properly by Beast Mode (the last single quote).
2.) I have never seen a Case When statement where a criteria was called between the Case and When. I am relatively new to this, so it might just be my lack of experience.
Any help would be appreciated!