Dashboards & Visualizations
Highlighted

color a column based on its content using xml code

New Member

i have a column status, which will have a message saying "successful" or "unsuccessful",
i want to color the cell green that has successful message
else if unsuccessful color it red.

please help me with the code

0 Karma
Highlighted

Re: color a column based on its content using xml code

SplunkTrust
SplunkTrust

@ramyaashok

    <dashboard>
      <label>Color Cell</label>
      <row>
        <panel>
          <table>
            <search>
              <query>| makeresults | eval status="successful,unsuccessful",status=split(status,",")| mvexpand status</query>
              <earliest>-24h@h</earliest>
              <latest>now</latest>
            </search>
            <option name="drilldown">none</option>
            <format type="color" field="status">
              <colorPalette type="map">{"successful":#00FF00,"unsuccessful":#FF0000}</colorPalette>
            </format>
          </table>
    </panel>
  </row>
</dashboard>

Refer: https://docs.splunk.com/Documentation/Splunk/7.3.1/Viz/TableFormatsXML#Table_format_source_code_exam...

0 Karma
Speak Up for Splunk Careers!

We want to better understand the impact Splunk experience and expertise has has on individuals' careers, and help highlight the growing demand for Splunk skills.