Apply color rules based on one column's values to other columns
There are so many use cases where this would be applicable. I am seeing a number of other discussions about this, but not any that are actually in the Idea Exchange. So I am posting it here just in case. If it already exists, someone please let me know and I will upvote that one.
Comments
-
I am not sure I understand the request. Color rules are by column unless the box is checked to apply to row. You can make multiple columns react to the same formula. Can you elaborate?
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
@ArborRose, I updated the title of my idea to be a little more descriptive. I can link this discussion where another user (@Kyle McMahon) is also describing what I am referring to and there is some existing comments about how it is currently not possible:
Here are a couple specific scenarios I currently have, but I know there are many more:
- I have a mega table where each line represents an item. I want a numeric column (dollars) to be color coded based on a different text column's values (item type). Currently, I have to apply the color coding to the entire table row, and then apply a "white" color rule to every other column in the table to "overwrite" all the other columns that I don't actually want that color coding applied to. There are also two caveats to this cumbersome workaround:
- I can only utilize it once within the table, because if I apply a different color rule to the entire table row as well, it overwrites the first one.
- Even though there is a priority order to applying color rules as they can overwrite each other like in this scenario, I can't conveniently click and drag to change the order of the color rules once they are set. I would reset every single color rule one-by-one in order to assert a color rule into the priority spot that I need it.
- In single value chart, I want to apply RAG color values to a numeric column (seconds) but I need to format the column into a legible value that displays in minutes and seconds (for example: 1 minute 7 seconds). I can create that calc, but now the color rules I have based on the numeric "seconds" column do not apply to my formatted, calc column, since it is now a text value and not numeric. And I cannot apply color rules using numeric ranges to the text value that will dynamically change.
0 - I have a mega table where each line represents an item. I want a numeric column (dollars) to be color coded based on a different text column's values (item type). Currently, I have to apply the color coding to the entire table row, and then apply a "white" color rule to every other column in the table to "overwrite" all the other columns that I don't actually want that color coding applied to. There are also two caveats to this cumbersome workaround:
-
Thank you for the additional information.
We need the ability to apply color rules to specific columns based on the values in a different column.
- Column-Specific Conditional Formatting Based on Another Column:
- Allow numeric or text columns to be color-coded based on the values of another column. For example:
- In a mega table, color-code a numeric column (e.g., "Dollars") based on the value of a text column (e.g., "Item Type") without applying the rule to the entire row.
- Allow numeric or text columns to be color-coded based on the values of another column. For example:
- Overlapping Color Rules with Adjustable Priorities:
- Enable multiple color rules to overlap without fully overriding each other and allow users to reorder the priority of these rules via a drag-and-drop interface.
- Numeric-Based Color Rules for Formatted Text Columns:
- Extend the ability to apply numeric-based color rules to formatted text values. For example:
- A calculated field that converts seconds into a "minutes" format should still support color rules based on numeric thresholds from the underlying data.
- Extend the ability to apply numeric-based color rules to formatted text values. For example:
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1 - Column-Specific Conditional Formatting Based on Another Column:
-
Yes, those 3 points are a perfect summary. Thank you!
0 -
EXACTLY what we're trying to do with our other posted idea!
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
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive