Trying to write a Beast Mode that calculates yesterday's date.
DATE_SUB(CURRENT_DATE(), interval 1 Days)
This formula validates just fine, but an error occurs when I try to use it in a table or see it in a drill down.
You have a minor typo in your formula, it should be DAY not DAYS
DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)
You can also shorten it since it defaults to DAY intervals: