Table Colors

[Jules22]

Please refer the below: 

 I need to apply color-coding to a dataset based on specific value criteria. The dataset contains dynamic date fields, and I want to assign colors to the values as follows:

- Green:  Values greater than 89
- Yellow: Values between 75 and 89 (inclusive)
- Orange: Values less than 75

- More Important:

Red: Values containing letters and commas (e.g., "PL", "SL", "32,0")

Could someone guide me on how to implement this logic in table tool? Specifically, I'm looking for advice on how to handle dynamic date fields and apply the color-coding efficiently.

[lwolfie]

I set the rules up for the first column 2025_03_03.  You were definitely close!  You would then copy them into the other columns.

[Jules22]

@lwolfie this isn't coloring the values with commas

[lwolfie]

It worked for me.  Make sure you have them in the correct order.  

ToNumber([_Currentfield_]) > 89  for Green is first rule

ToNumber([_Currentfield_]) > 75 AND ToNumber([_Currentfield_]) < 89  for Yellow is the 2nd

REGEX_MATCH([_Currentfield_], "\d+") AND Tonumber([_currentfield_]) < 75 for orange is the 3rd

Contains([_Currentfield_], ",") OR REGEX_MATCH([_Currentfield_], "\u+") for red is the 4th

[Andrew-Merrill-CoG · Accepted solution]

I took a slightly different approach and set up a dynamic configuration for the tool by configuring the "Dynamic or Unknown Field" Column Rules before connecting the Table Tool to the rest of the workflow. As @lwolfie make sure that your rules are ordered properly.

Hope this helps and Happy Solving!

[Jules22]

a

[Jules22]

a

[Jules22]

a

[Jules22]

1

[Jules22]

1