https://community.splunk.com/t5/Dashboards-Visualizations/Changing-the-color-of-the-number-in-dashboard-that-have-a-string/m-p/535436#M36522 <P>You may use the format number option in the visualization</P><LI-CODE lang="markup"> &lt;format type="number" field="perc"&gt; &lt;option name="unit"&gt;%&lt;/option&gt; &lt;/format&gt;</LI-CODE><P>Here is a run anywhere example</P><LI-CODE lang="markup">&lt;form&gt; &lt;label&gt;Colors&lt;/label&gt; &lt;fieldset submitButton="false"&gt; &lt;input type="text" token="perc"&gt; &lt;label&gt;Input Percentage&lt;/label&gt; &lt;default&gt;20&lt;/default&gt; &lt;initialValue&gt;20&lt;/initialValue&gt; &lt;/input&gt; &lt;/fieldset&gt; &lt;row&gt; &lt;panel&gt; &lt;table&gt; &lt;search&gt; &lt;query&gt;|makeresults|eval Percentage=$perc$&lt;/query&gt; &lt;earliest&gt;-15m&lt;/earliest&gt; &lt;latest&gt;now&lt;/latest&gt; &lt;/search&gt; &lt;option name="drilldown"&gt;none&lt;/option&gt; &lt;option name="refresh.display"&gt;progressbar&lt;/option&gt; &lt;format type="color" field="perc"&gt; &lt;colorPalette type="list"&gt;[#53A051,#006D9C,#F8BE34,#F1813F,#DC4E41]&lt;/colorPalette&gt; &lt;scale type="threshold"&gt;0,30,70,100&lt;/scale&gt; &lt;/format&gt; &lt;format type="number" field="perc"&gt; &lt;option name="unit"&gt;%&lt;/option&gt; &lt;/format&gt; &lt;format type="color" field="Percentage"&gt; &lt;colorPalette type="list"&gt;[#DC4E41,#F1813F,#F8BE34,#53A051]&lt;/colorPalette&gt; &lt;scale type="threshold"&gt;20,40,60&lt;/scale&gt; &lt;/format&gt; &lt;format type="number" field="Percentage"&gt; &lt;option name="unit"&gt;%&lt;/option&gt; &lt;/format&gt; &lt;/table&gt; &lt;/panel&gt; &lt;panel&gt; &lt;single&gt; &lt;search&gt; &lt;query&gt;|makeresults|eval Percentage=$perc$&lt;/query&gt; &lt;earliest&gt;-15m&lt;/earliest&gt; &lt;latest&gt;now&lt;/latest&gt; &lt;/search&gt; &lt;option name="colorMode"&gt;none&lt;/option&gt; &lt;option name="drilldown"&gt;none&lt;/option&gt; &lt;option name="rangeColors"&gt;["0xdc4e41","0xdc4e41","0xf8be34","0xf1813f","0x53a051"]&lt;/option&gt; &lt;option name="rangeValues"&gt;[0,20,40,60]&lt;/option&gt; &lt;option name="refresh.display"&gt;progressbar&lt;/option&gt; &lt;option name="unit"&gt;%&lt;/option&gt; &lt;option name="useColors"&gt;1&lt;/option&gt; &lt;/single&gt; &lt;/panel&gt; &lt;/row&gt; &lt;/form&gt;</LI-CODE> Tue, 12 Jan 2021 07:37:04 GMT renjith_nair 2021-01-12T07:37:04Z https://community.splunk.com/t5/Dashboards-Visualizations/Changing-the-color-of-the-number-in-dashboard-that-have-a-string/m-p/535434#M36521 <P>To be specific, I have a dashboard panel that show percentage of timed out transaction, and I want it to change color to alert red when it reach 20% or more. When I use the Edit dashboard/Format visualization/Color, it can only change if the showed result is number, because my result is a number, with a "%" attached to it, it have no effect, here is my code</P><P>&nbsp;</P><LI-CODE lang="markup">|eval Timed_Out =round((Timed/Total)*100,2)."%" |table Timed_Out</LI-CODE><P>&nbsp;</P><P>So is there a way for the showed result automatically have "%" so the Format Visualization could work?</P><P>Thank you</P> Tue, 12 Jan 2021 07:24:52 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Changing-the-color-of-the-number-in-dashboard-that-have-a-string/m-p/535434#M36521 phamxuantung 2021-01-12T07:24:52Z https://community.splunk.com/t5/Dashboards-Visualizations/Changing-the-color-of-the-number-in-dashboard-that-have-a-string/m-p/535436#M36522 <P>You may use the format number option in the visualization</P><LI-CODE lang="markup"> &lt;format type="number" field="perc"&gt; &lt;option name="unit"&gt;%&lt;/option&gt; &lt;/format&gt;</LI-CODE><P>Here is a run anywhere example</P><LI-CODE lang="markup">&lt;form&gt; &lt;label&gt;Colors&lt;/label&gt; &lt;fieldset submitButton="false"&gt; &lt;input type="text" token="perc"&gt; &lt;label&gt;Input Percentage&lt;/label&gt; &lt;default&gt;20&lt;/default&gt; &lt;initialValue&gt;20&lt;/initialValue&gt; &lt;/input&gt; &lt;/fieldset&gt; &lt;row&gt; &lt;panel&gt; &lt;table&gt; &lt;search&gt; &lt;query&gt;|makeresults|eval Percentage=$perc$&lt;/query&gt; &lt;earliest&gt;-15m&lt;/earliest&gt; &lt;latest&gt;now&lt;/latest&gt; &lt;/search&gt; &lt;option name="drilldown"&gt;none&lt;/option&gt; &lt;option name="refresh.display"&gt;progressbar&lt;/option&gt; &lt;format type="color" field="perc"&gt; &lt;colorPalette type="list"&gt;[#53A051,#006D9C,#F8BE34,#F1813F,#DC4E41]&lt;/colorPalette&gt; &lt;scale type="threshold"&gt;0,30,70,100&lt;/scale&gt; &lt;/format&gt; &lt;format type="number" field="perc"&gt; &lt;option name="unit"&gt;%&lt;/option&gt; &lt;/format&gt; &lt;format type="color" field="Percentage"&gt; &lt;colorPalette type="list"&gt;[#DC4E41,#F1813F,#F8BE34,#53A051]&lt;/colorPalette&gt; &lt;scale type="threshold"&gt;20,40,60&lt;/scale&gt; &lt;/format&gt; &lt;format type="number" field="Percentage"&gt; &lt;option name="unit"&gt;%&lt;/option&gt; &lt;/format&gt; &lt;/table&gt; &lt;/panel&gt; &lt;panel&gt; &lt;single&gt; &lt;search&gt; &lt;query&gt;|makeresults|eval Percentage=$perc$&lt;/query&gt; &lt;earliest&gt;-15m&lt;/earliest&gt; &lt;latest&gt;now&lt;/latest&gt; &lt;/search&gt; &lt;option name="colorMode"&gt;none&lt;/option&gt; &lt;option name="drilldown"&gt;none&lt;/option&gt; &lt;option name="rangeColors"&gt;["0xdc4e41","0xdc4e41","0xf8be34","0xf1813f","0x53a051"]&lt;/option&gt; &lt;option name="rangeValues"&gt;[0,20,40,60]&lt;/option&gt; &lt;option name="refresh.display"&gt;progressbar&lt;/option&gt; &lt;option name="unit"&gt;%&lt;/option&gt; &lt;option name="useColors"&gt;1&lt;/option&gt; &lt;/single&gt; &lt;/panel&gt; &lt;/row&gt; &lt;/form&gt;</LI-CODE> Tue, 12 Jan 2021 07:37:04 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Changing-the-color-of-the-number-in-dashboard-that-have-a-string/m-p/535436#M36522 renjith_nair 2021-01-12T07:37:04Z