"current year, current month" and "previous year, current month" Beast Modes
I'm trying to create a 'current year, current month' and 'previous year, current month' beast mode.
To this point I have created a current year to date but am not sure of the syntax. I have watch multiple videos and have searched high and low through domos resources.
Any help with the syntax would be helpful
Here is the beast mode that we have that works for the 'current year to date' and previous year to date:
case when year(`Transaction Date`) = year(CURDATE()) then `amount` end
Case when Year(`Transaction Date`) = Year(curdate())-1 then `amount` end
If this helps, feel free to agree, accept or awesome it!
- 10.6K All Categories
- 13 Getting Started in the Community
- 29 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 300 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board