Hi,
I am trying to change values in a standard bar chart based on threshold values. I have tried following some other documents
http://splunk-base.splunk.com/answers/58335/change-chart-bar-color-based-on-data-value and tried rangemap around this area but have not been able to successfully implement it in my charts.
Here is the XML code:
<?xml version='1.0' encoding='utf-8'?>
<dashboard>
<label>SQL Dashboard</label>
<row>
<chart>
<searchString>index=perf collection="Processor Information" counter counter="% Processor Time" host="LIVE2012SQL01" | stats Max(Value) AS Percent </searchString>
<title>SQL CPU</title>
<earliestTime>-1m</earliestTime>
<latestTime>now</latestTime>
<option name="charting.chart">fillerGauge</option>
<option name="charting.chart.rangeValues">[0,14,30,50]</option>
<option name="charting.chart.style">shiny</option>
<option name="charting.gaugeColors">[0x84e900,0xffe800,0xbf3030]</option>
<option name="count">10</option>
<option name="displayRowNumbers">true</option>
</chart>
<chart>
<searchName>SQL Page File Usage</searchName>
<title>Page File Usage</title>
<option name="charting.chart">column</option>
<option name="charting.chart.rangeValues">[0,0.5,2,5]</option>
<option name="charting.gaugeColors">[0x84e900,0xffe800,0xbf3030]</option>
<option name="charting.seriesColors">[0x66CC66]</option>
<option name="count">10</option>
<option name="displayRowNumbers">true</option>
<option name="drilldown">all</option>
<option name="maxLines">10</option>
<option name="segmentation">outer</option>
<option name="softWrap">true</option>
</chart>
<chart>
<searchName>SQL Mem Usage</searchName>
<title>SQL Memory Usage (Physical RAM + Virtual RAM)</title>
<option name="charting.chart">column</option>
<option name="charting.chart.stackMode">default</option>
<option name="charting.seriesColors">[0x66CC66]</option>
<option name="count">10</option>
<option name="displayRowNumbers">true</option>
</chart>
</row>
<row>
<chart>
<searchName>SQL Stats 1</searchName>
<title>SQL Stats</title>
<option name="charting.chart">column</option>
<option name="charting.chart.nullValueMode">zero</option>
<option name="charting.chart.stackMode">default</option>
<option name="charting.seriesColors">[0x66CC66]</option>
<option name="count">10</option>
<option name="displayRowNumbers">true</option>
</chart>
<chart>
<searchName>SQL Tran Log Usage</searchName>
<title>SQL Transaction Logs</title>
<option name="charting.chart">bar</option>
<option name="charting.seriesColors">[0x66CC66]</option>
<option name="count">10</option>
<option name="dataOverlayMode">highlow</option>
<option name="displayRowNumbers">true</option>
</chart>
<chart>
<searchString>index=sqlperf counter="Page life expectancy" NOT _Total | sort - Value | top limit=10000 Value by counter | stats max(Value) by counter
</searchString>
<title>SQL Performance</title>
<earliestTime>-5m</earliestTime>
<latestTime>now</latestTime>
<option name="charting.axisTitleX.text">Meseaure</option>
<option name="charting.axisTitleY.text">Value</option>
<option name="charting.chart">column</option>
<option name="charting.primaryAxisTitle.text"/>
<option name="charting.secondaryAxisTitle.text"/>
<option name="charting.seriesColors">[0x66CC66]</option>
<option name="count">10</option>
<option name="displayRowNumbers">true</option>
<option name="maxLines">10</option>
<option name="segmentation">outer</option>
<option name="softWrap">true</option>
</chart>
</row>
<row>
<chart>
<searchString>index=sqlperf collection="SQLServer:General Statistics" counter="User Connections" | stats count AS Total by counter rangemap field=count low=0-5 elevated=6-10 default=severe</searchString>
<title>SQL User Connections </title>
<earliestTime>-1m</earliestTime>
<latestTime>now</latestTime>
<option name="charting.chart">column</option>
<option name="charting.chart.stackMode">default</option>
<option name="charting.seriesColors">[0x66CC66]</option>
<option name="count">10</option>
<option name="displayRowNumbers">true</option>
</chart>
<chart>
<searchString>sourcetype="WinEventLog:Application" BlinkBox.DatabaseTimeoutException host="liveweb*" | stats count AS Total</searchString>
<title>SQL Timeouts</title>
<earliestTime>-1m</earliestTime>
<latestTime>now</latestTime>
<option name="charting.chart">radialGauge</option>
<option name="charting.seriesColors">[0x66CC66]</option>
<option name="count">10</option>
<option name="displayRowNumbers">true</option>
</chart>
<chart>
<searchName>SQL Disk Status</searchName>
<title>SQL Disk Status</title>
<option name="charting.axisTitleY.text">milliseconds (ms)</option>
<option name="charting.chart">column</option>
<option name="charting.secondaryAxisTitle.text"/>
<option name="charting.seriesColors">[0x66CC66]</option>
<option name="count">10</option>
<option name="displayRowNumbers">true</option>
</chart>
</row>
</dashboard>
Here is a an example of a search which is a bar chart in my dashboard.
index=sqlperf collection="SQLServer:General Statistics" counter="User Connections"
| stats count AS Total by counter
Thanks
... View more