Domo IDEAs Conference - Beast Modes - Conditional Formatting

GrantSmith
Coach

in Magic ETL
Greetings! This is another post highlighting a beast mode from my Domo IDEAs conference session. This one covers how to format numbers a number when concatenating with a string.
Problem:
Conditionally color a number based on a specific condition
Solution:
We can utilize the <div>
and <span>
tags with some CSS styling code to specify some color and conditionally combine those with a color value using CASE
and CONCAT
- -- Author:
- -- Created:
- -- Last Modified:
- -- Description: Use a CASE statement to conditionally color even numbers as green and odd numbers as red
- -- MOD([VALUE], 2) returns the remainder of dividing the [VALUE] by 2. 0 for even and 1 for odd.
- -- The coloring is using <div> and <span> with styling to perform the colorization
- -- Note: This only works with an HTML table card.
- CONCAT('<div><span style="color: ',
- CASE WHEN MOD(FLOOR(SUM(`random_number`)), 2) = 0 THEN 'green' ELSE 'red' END,
- '">',
- FLOOR(SUM(`random_number`)),
- '</span></div>')
Note:
Because HTML coding / tags are being utilized an HTML table is the only card which will support this.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
**Did this solve your problem? Accept it as a solution!**
2
Comments
-
Here's a link to the video of my session outlining this beast mode: https://www.youtube.com/watch?v=gO8OLpsAk4M&index=6
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Welcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign InWelcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign InCategories
- 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
- 116 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive