Want to change color of statistic table cell value on certain rule using other field.
TABLE:
Region, Device, Service, Leased License, Reserved License, Maximum License, Current Users
CHINA | AMCDPVPN1 | DESKTOP | 1700 | 1700 | 2000 | 638 |
SCLAMPVPN1 | 100 | 100 | 200 | 0 | ||
Republic Of Korea | AMKDPVPN1 | DESKTOP | 1000 | 1000 | 1300 | 294 |
INDIA | AMINDDPVPN1 | DESKTOP | 2200 | 1900 | 2500 | 2083 |
SCLA | SCLADPVPN1 | DESKTOP | 4000 | 4000 | 5000 | 549 |
"current users" cell should have color as below mentioned rule.
1. RED: if "Current Users" greater than or equal to "Reserved License"
2. YELLOW: if "Current users" greater than 85% of "Reserved License" and less than "Reserved License"
3. GREEN: If "Current users" less than 85% of "Reserved License"
Make current users a multi-value field with the second value evaluated to the colour you want (dependent on the conditions you mentioned). Then format the field colour based on the colour, and add CSS to hide the second multi-value in the current users column. See my solution to this post https://community.splunk.com/t5/Splunk-Search/How-to-color-the-columns-based-on-previous-column-valu...