I try to change the font colour within a chart. Unfortunately I can only create dashboards and don't have any admin rights. Here is my search:
index=int Up | rex field=_raw "Up (?.*) \((?.*)\);(?.*);(?.*);(?.*)" | chart values(status) BY host name useother=false
I would like to have the font color green if the values(status) is "healthy" and red if the values(status) is "unhealthy". Unfortunately, I can't change the color directly at the field, because the field names are also dynamic (name).
Do you have any idea how I can manage this ?
Thank you in advance for your support
@jmauritz is this for Table visualization or Chart? What does your current visualization look like and what is the expected output? If you can add a screenshot/mock up for both that would be great for the community members to assist.
If you are looking for color based on values like
unhealthy you can use Table visualization and Color based on cell value which is available in version 6.5 and higher. The same can be done either directly via
UI > Edit > Format Visualization > Edit Table Column > Table Cell Color by Value or else using table Simple XML configuration.
On separate notes, while posting the code use the
code button i.e. 101010 or shortcut
Ctrl+G, to ensure that special characters do not escape. As per your current code what if a host has both values health and unhealthy for the same host.