Beast Mode Week Revenue Calculation
This should be a fairly straight forward question. So I need to do a calculation that finds the revenue from 12 weeks ago. I know that I can use weekofyear(). However, since it's only 6 weeks into 2018. This method wouldn't work untill later in the year. Is there a beast mode function that allows me to actually get the weeks from 2017? A friend on Domo suggested this as a solution but it won't give me the revenue from 12 weeks ago. Please see screenshot for details.