BeastMode: Identify Odd or Even Year
This is something I solved on my own, wanting to share here in case someone else can use this approach. Also would love to hear if you have another way to provide the same solution.
What was the business problem? I have a card that displays a KPI as a % over time. I wanted to color code the years so they alternate between two colors based on the year being an odd or even number.
Using the "Odd or Even" approach in the color rules future proofs the solution so I don't have to state the year explicitly.
The BeastMode I came up with is a simple case statement that subtracts the charted year (in my case `Order Date`) from the year of the current date:
case
when YEAR(CURDATE())-YEAR(`Order Date`)=0 then 'Even'
when YEAR(CURDATE())-YEAR(`Order Date`)=2 then 'Even'
when YEAR(CURDATE())-YEAR(`Order Date`)=4 then 'Even'
when YEAR(CURDATE())-YEAR(`Order Date`)=6 then 'Even'
when YEAR(CURDATE())-YEAR(`Order Date`)=8 then 'Even'
else 'Odd'
end
Best Answer
-
@swagner you can use the MOD function to see if there is a remainder when dividing by 2 to determine if it is an odd or even number:
CASE WHEN MOD(YEAR(`Order Date`),2) = 0 THEN 'Even'
ELSE 'Odd'
END
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2
Answers
-
@swagner you can use the MOD function to see if there is a remainder when dividing by 2 to determine if it is an odd or even number:
CASE WHEN MOD(YEAR(`Order Date`),2) = 0 THEN 'Even'
ELSE 'Odd'
END
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
@MarkSnodgrass Thank you! Hope all is well with you sir.
1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 778 Automate
- 190 Apps
- 482 APIs & Domo Developer
- 83 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive