Current Year, Prior Year, and Budget on Same Card
I'm trying to build a car with Budget, Current Year Actuals, and Prior Year Actuals. I created the view I wanted (see attachment), however, I had to use BeastMode. I can't filter easily with the way I had to write the BeastMode.
PROBLEM: Create a card with CY Actuals, PY Actuals, and Budget on one card with the ability to adjust Page Filters and have the card update.
Note: I've tried the Period over Period chart type without success. I have Budget as part of the underlying data, but can't get it to show up. There is not an option for "Series" in the Period over Period chart type.
when `Order Amount (Global)` and YEAR(`Date`) = YEAR(CURRENT_DATE()) then 'CY Actuals'
when `Order Amount (Global)` and Year(`Date`) = YEAR(CURRENT_DATE())-1 then 'PY Actuals'
when `Orders Budget (Global)` and YEAR(`Date`) = YEAR(CURRENT_DATE()) then 'Budget'
Else '2+ Years'