Pivot table conditional formatting for text and column totals to the left
Hi,
I have a card where I need to show a % total of an opening number and would like the text to be green if 100% or greater and red if less than 100% - in the chart properties I can set colour rules but this only seems to apply to the fill colour, is there any way to have the fill colour remain the same but have the text colour with the conditional formatting?
Also in another card I have totals in the column after my data but would like to show this before - I can see an option to do this for rows in the chart properties but I can't see a similar option for columns, does this exist?
Any help would be much appreciated!
Best Answers
-
You can color just the text by sliding the opacity to 0 and then selecting one of the first 3 text options and unselect apply format to table row.
This video walks you through how to do it.
I think you would need to switch to a pivot table if you want total positions for both rows and columns
**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.2 -
I haven't found Domo to be very flexible in creating cards with different borders or colors. I don't know a simple way to do this, but you could try it with a some kind of html chart that uses CSS.
/* Default text color */
.myValue {
color: green;
}
/* Text color when condition is met */
.myValue {
color: red;
}** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1
Answers
-
You can color just the text by sliding the opacity to 0 and then selecting one of the first 3 text options and unselect apply format to table row.
This video walks you through how to do it.
I think you would need to switch to a pivot table if you want total positions for both rows and columns
**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.2 -
I haven't found Domo to be very flexible in creating cards with different borders or colors. I don't know a simple way to do this, but you could try it with a some kind of html chart that uses CSS.
/* Default text color */
.myValue {
color: green;
}
/* Text color when condition is met */
.myValue {
color: red;
}** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive