How to change Text Color in table, but not Cell Color
Comments
-
Hi @Neeti,
I tried using your piece of code. In my case, I am using a pivot tabl and not a table. Your code seems to color the background in a table, but we are interested in coloring the text only, not the background.
Do you know what parameter it is?Moreover, did you try it for a pivot table or a regular table?
Thanks!0 -
HI,
You can try color rules also, which will either change cell color or row color, based on your selection in color rule window. I have tried this on both pivot and normal table. Also, SUmo table will have more effective color rule implementation. Did you try sumo tables?
Thanks,
Neeti
0 -
Hi! I am using this to color a cell for a Mega Table:
CONCAT('<div style="background-color:#69ff96; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">',CONCAT(`Month Data.ABSENTEEISM`, '%',' ', '(', CASE WHEN `Variance ABSENTEEISM` > 0 THEN '+' ELSE '' END , SUBSTRING(`Variance ABSENTEEISM`, 1, 5),'%', ')'), '</a></div>')
The problem is that, no matter the number I change in the div, I always see a light blue value.
Basically I need to green and red colours
, so I can paint the value based on a condition.
0 -
AFAIK, Mega tables do not support HTML formatting. HTML tables do, but they don't have all the functionality of Mega Tables (on the fly sorting or scrolling).
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 526 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 440 Beast Mode
- 23 Variables
- 514 Automate
- 115 Apps
- 391 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 67 Manage
- 67 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive