Color Code a Beast mode column in the table
Hi All,
I have a beast mode column by the name ( % Aloc on 3yr sale) which I have renamed in the table as (%3yrsale) and I have to highlight the values in the table to be orange or mild red...Can you please let me know how to go about the beast mode for the same..
Best Answers
-
Hi @ozarkram
you can use an HTML table and some conditional coding in a beast mode to accomplish this. I have a talk at DP22 about this topic and did a write up here: https://dojo.domo.com/discussion/54554/dp22-using-beast-mode-to-build-data-storytelling-formatting-text
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
I would suggest using the Heatmap Table chart type under Tables and Textboxes in the chart selector.
In the chart properties, make the following adjustments:
Under Theme, select a color theme that has the range of colors you want to use.
Under Scale, select Independent Column Ranges, so that each column will be colored independently.
Under General, enter the column number or range of columns you want colored. You can enter a range, such as 3-12, or you can separte them by commas, such as 1, 2, 4
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
You chose Heat Map for your chart type, which is actually different from the Heat Map Table. On the right side, choose Tables and Textboxes from the Chart Types dropdown list. Then choose Heatmap table for the chart type.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
@ozarkram you have an extra closing parentheses at the ends of sum(`LY SALES`). There should only be one
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Hi @ozarkram
you can use an HTML table and some conditional coding in a beast mode to accomplish this. I have a talk at DP22 about this topic and did a write up here: https://dojo.domo.com/discussion/54554/dp22-using-beast-mode-to-build-data-storytelling-formatting-text
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
I would suggest using the Heatmap Table chart type under Tables and Textboxes in the chart selector.
In the chart properties, make the following adjustments:
Under Theme, select a color theme that has the range of colors you want to use.
Under Scale, select Independent Column Ranges, so that each column will be colored independently.
Under General, enter the column number or range of columns you want colored. You can enter a range, such as 3-12, or you can separte them by commas, such as 1, 2, 4
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Hi @GrantSmith ,
I have an error in this formula below:
CONCAT('<span style="color: ',
CASE WHEN SUM(`BAM ALOC`)/sum(`LY SALES`) <> 0 THEN 'red' ELSE 'green' END,
SUM(`BAM ALOC`)/sum(`LY SALES`)),
'</span>’)
Can you please help me here..
0 -
Hi @MarkSnodgrass : Appreciate your response!..
When I try to select the heatmap table the entire dataset changes to a heatmap....I am not able to see the chart properties at all.....
0 -
Within Analyzer, make sure Properties is selected. This will allow you to adjust the chart properties. You will then want to go to General and enter in which columns you want to apply the heatmap to as I referenced above.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Hi @MarkSnodgrass , Following are the options available in my general option
font Size Default
Inner Margin
Balanced Distribution
Disable Animation
Override Maximum Value
Reverse Color Direction
No Data Message
0 -
You chose Heat Map for your chart type, which is actually different from the Heat Map Table. On the right side, choose Tables and Textboxes from the Chart Types dropdown list. Then choose Heatmap table for the chart type.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
@ozarkram you have an extra closing parentheses at the ends of sum(`LY SALES`). There should only be one
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Thank you so much @GrantSmith and @MarkSnodgrass !..Really appreciate your help!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 60 App Studio
- 41 Variables
- 687 Automate
- 177 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 126 Manage
- 123 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive