color of column chart

[surekhasplunk]

I have a graph like this. Now i want to highlight and make red only if Available value is less than 100 in the x axis.
how to do that.

[vnravikumar · Accepted solution]

Hi

Try like and adjust as per your requirement

<dashboard>
  <label>chart color</label>
  <row>
    <panel>
      <chart>
        <search>
          <query>index="_internal" |stats count by source | eval redCritical = if(count<= 10000,count ,0) | eval yellowWarning = if(count>= 10001,count ,0)</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="charting.chart">column</option>
        <option name="charting.drilldown">none</option>
        <option name="charting.legend.labels">[redCritical,yellowWarning]</option>
     <option name="charting.seriesColors">[0xFF0000,0xFFFF00]</option>
      </chart>
    </panel>
  </row>
</dashboard>