Dashboards & Visualizations

How to set specific colours to Bar Chart?

POR160893
Builder

Hi,

I have the following bar chart:

POR160893_0-1660298526898.png


The query for this bar chart is this:
| inputlookup Migration-Status-All.csv
| search Vendor = "McAfee"
| stats count by "Migration Comments"
| eventstats sum(count) as Total
| eval perc=round(count*100/Total,2)
| eval dummy = 'Migration Comments'
| chart sum(perc) over "Migration Comments" by dummy

I need to have the "In Progress" bar to be yellow and the "Not Started" bar to be red ..... I tried using an eval and Case but didn't work for me.

How can this be done?

Many thanks!

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

ITWhisperer
SplunkTrust
SplunkTrust
        <option name="charting.fieldColors">
          {"In Progress": 0xFFFF00, "Not Started": 0xFF0000}
        </option>

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust
        <option name="charting.fieldColors">
          {"In Progress": 0xFFFF00, "Not Started": 0xFF0000}
        </option>
Get Updates on the Splunk Community!

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...