Dashboards & Visualizations

Change the bar chart color based on states

Explorer

Hi All,
Can someone help me in changing the color based on the state

I tried charting.fieldColors in option field, but its not working

CHART is giving only one color,its not changing based on the condition

alt text

Labels (2)
Tags (1)
0 Karma
1 Solution

Explorer

Thank you for replying vnravikumar

But after trying your code, I cannot see any change in the color for those different states, all the state showing the same color, that is the issue, I want different color for each state.

View solution in original post

0 Karma

Explorer

Thank you for replying vnravikumar

But after trying your code, I cannot see any change in the color for those different states, all the state showing the same color, that is the issue, I want different color for each state.

View solution in original post

0 Karma

Champion

have you used transpose command?

0 Karma

Explorer

Thank you vnravikumar!!!

transpose command worked.

0 Karma

Champion

Can you please accept my answer?

Explorer

accepted ...

0 Karma

Champion

Hi

Check this sample

<dashboard>
  <label>chart</label>
  <row>
    <panel>
      <chart>
        <search>
          <query>index=_internal 
| stats count by sourcetype 
| transpose 0 header_field=sourcetype |fields - column</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="charting.chart">column</option>
        <option name="charting.drilldown">none</option>
           <option name="charting.seriesColors">[0x1e93c6, 0xf2b827, 0xd6563c, 0x6a5c9e, 0x31a35f, 0xed8440, 0x3863a0, 0xa2cc3e, 0xcc5068, 0x73427f, 0x11a88b]</option>
      </chart>
    </panel>
  </row>
</dashboard>