topic Re: Can you help us change the color on the background of a single value visualization? in Dashboards & Visualizations

Can you help us change the color on the background of a single value visualization?

jip31 — Thu, 27 Dec 2018 07:42:24 GMT

Hi,

I use a single value in a dashboard which returns GOOD or BAD.

If the value is GOOD, I want to color the background in green and in red if it's BAD
But I don't have this possibility in the single value format.

| eval Status=if(Status="OK", "GOOD", "BAD") 
| table Status

Could you help me please??

Re: Can you help us change the color on the background of a single value visualization?

p_gurav — Thu, 27 Dec 2018 07:51:35 GMT

Option of color based on value is there in Format

Re: Can you help us change the color on the background of a single value visualization?

niketn — Thu, 27 Dec 2018 08:19:41 GMT

@jip31, have you checked out Status Indicator Custom Visualization which seems a better match for this use case?
Refer to one of my older answers: https://answers.splunk.com/answers/670058/how-can-i-get-colors-into-trellis-for-values-that.html

Re: Can you help us change the color on the background of a single value visualization?

jip31 — Fri, 28 Dec 2018 05:44:04 GMT

hi its interesting i wasnt know this addon but i can test it because I work in client server mode and i have not the possibility to install it
its not possible to do what i want with colorpalette???

Re: Can you help us change the color on the background of a single value visualization?

niketn — Fri, 28 Dec 2018 12:14:49 GMT

@jip31 since you do not have access for installing custom visualization apps, I would expect you can't use JavaScript static file as well, otherwise one of the options would be to use Simple XML JS extension to color Single Value based on values using JavaScript: https://answers.splunk.com/answers/583539/can-we-set-two-different-colors-for-single-value-a.html

You can also check out Custom Decorations example in the Splunk Dashboard Examples App which also uses Simple XML CSS Extension in <html> panel, where CSS changes can be brought inside Simple XML Dashboard.

Following is a list of 4 other options to Color Single Value, with their advantage/disadvantage. See whichever fits best (hopefully on of CSS overrides ;)):

Following is the complete Simple XML code:

<dashboard>
  <label>Single Value Color By Rangemap</label>
  <row>
    <panel>
      <title>Option 1: Single Value Color with rangemap (caution while editing as rangemap can get overridden)</title>
      <single>
        <search>
          <query>| makeresults 
| eval state="GOOD"
| table state
| eval severity=case(state="GOOD", 0, state="BAD", 1)
| rangemap field=severity low=0-0 default=severe</query>
          <earliest>-15m</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">none</option>
        <option name="drilldown">none</option>
        <option name="numberPrecision">0</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="unitPosition">after</option>
        <option name="useColors">0</option>
      </single>
      <single>
        <search>
          <query>| makeresults 
| eval state="BAD"
| table state
| eval severity=case(state="GOOD", 0, state="BAD", 1)
| rangemap field=severity low=0-0 default=severe</query>
          <earliest>-15m</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">none</option>
        <option name="drilldown">none</option>
        <option name="numberPrecision">0</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="unitPosition">after</option>
        <option name="useColors">0</option>
      </single>
      <html>
        <div>
          <a href="https://docs.splunk.com/Documentation/Splunk/latest/Viz/SingleValueFormatting#Migration_for_rangemap_settings_in_existing_single_value_visualizations">Single Value rangemap migration.</a>
        </div>
      </html>
    </panel>
  </row>
  <row>
    <panel>
      <title>Option 2: Deprecated classField option</title>
      <single>
        <search>
          <query>| makeresults 
| eval state="GOOD"
| table state
| eval severity=case(state="GOOD", 0, state="BAD", 1)
| rangemap field=severity low=0-0 default=severe</query>
          <earliest>-15m</earliest>
          <latest>now</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="useColors">0</option>
        <option name="useThousandSeparators">1</option>
        <option name="classField">severity</option>
        <option name="field">state</option>
      </single>
      <single>
        <search>
          <query>| makeresults 
| eval state="BAD"
| table state
| eval severity=case(state="GOOD", 0, state="BAD", 1)
| rangemap field=severity low=0-0 default=severe</query>
          <earliest>-15m</earliest>
          <latest>now</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="useColors">0</option>
        <option name="useThousandSeparators">1</option>
        <option name="classField">severity</option>
        <option name="field">state</option>
      </single>
      <html>
        <div>
          <a href="https://docs.splunk.com/Documentation/Splunk/latest/Viz/PanelreferenceforSimplifiedXML#single_value">Single Value Simple XML Configuration</a>
        </div>
      </html>
    </panel>
  </row>
  <row>
    <panel>
      <title>Option 3: Token for Single Value Block color using CSS Override</title>
      <html depends="$alwaysHideCSSStylePanel$">
        <style>
          #singleWithCSSOverride1 svg.svg-container rect{
            fill: $tokColor1$ !important;
          }
          #singleWithCSSOverride2 svg.svg-container rect{
            fill: $tokColor2$ !important;
          }
        </style>
      </html>
      <single id="singleWithCSSOverride1">
        <search>
          <query>| makeresults 
| eval state="GOOD"
| table state</query>
          <earliest>-15m</earliest>
          <latest>now</latest>
          <done>
            <eval token="tokColor1">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval>
          </done>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="rangeColors">["0x555","0x555"]</option>
        <option name="rangeValues">[0]</option>
        <option name="useColors">1</option>
      </single>
      <single id="singleWithCSSOverride2">
        <search>
          <query>| makeresults 
| eval state="BAD"
| table state</query>
          <earliest>-15m</earliest>
          <latest>now</latest>
          <done>
            <eval token="tokColor2">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval>
          </done>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="rangeColors">["0x555","0x555"]</option>
        <option name="rangeValues">[0]</option>
        <option name="useColors">1</option>
      </single>
    </panel>
  </row>
  <row>
    <panel>
      <title>Option 4: Token for Single Value Text color using CSS Override</title>
      <html depends="$alwaysHideCSSStylePanel$">
        <style>
          #singleWithCSSOverride3 svg.svg-container text.single-result{
            fill: $tokColor1$ !important;
          }
          #singleWithCSSOverride4 svg.svg-container text.single-result{
            fill: $tokColor2$ !important;
          }
        </style>
      </html>
      <single id="singleWithCSSOverride3">
        <search>
          <query>| makeresults 
| eval state="GOOD"
| table state</query>
          <earliest>-15m</earliest>
          <latest>now</latest>
          <done>
            <eval token="tokColor1">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval>
          </done>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">none</option>
        <option name="rangeColors">["0x555","0x555"]</option>
        <option name="rangeValues">[0]</option>
        <option name="useColors">1</option>
      </single>
      <single id="singleWithCSSOverride4">
        <search>
          <query>| makeresults 
| eval state="BAD"
| table state</query>
          <earliest>-15m</earliest>
          <latest>now</latest>
          <done>
            <eval token="tokColor2">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval>
          </done>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">none</option>
        <option name="rangeColors">["0x555","0x555"]</option>
        <option name="rangeValues">[0]</option>
        <option name="useColors">1</option>
      </single>
    </panel>
  </row>
</dashboard>

Re: Can you help us change the color on the background of a single value visualization?

jip31 — Sat, 29 Dec 2018 15:16:17 GMT

@niketnilay
hi
I choose the option 3 but i have a question
in one panel I can have GOOD or BAD value

    <panel>
      <title>Disk Remaining Space Status</title><html depends="$alwaysHideCSSStylePanel$">
       <style>
          #singleWithCSSOverride1 svg.svg-container rect{
             fill: $tokColor1$ !important;
           #singleWithCSSOverride2 svg.svg-container rect{
             fill: $tokColor2$ !important;
           }
        </style>
       </html>
      <single id="singleWithCSSOverride1">
        <search><query>| loadjob savedsearch="admin:FO_Workstations_Monitoring:FO_Workstations_Disk_Size"| eval state="GOOD"</query>
          <earliest>-30d@d</earliest>
          <latest>now</latest>
<done><eval token="tokColor1">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval></done></search>
<option name="colorBy">value</option>
<option name="colorMode">block</option>
<option name="rangeColors">["0x555","0x555"]</option>
<option name="rangeValues">[0]</option>
<option name="useColors">1</option></single>

So I want to add an eval state="BAD" in but i dont understand how to do
Do I have to add something in eval token="tokColor1">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")?
Thanks for your help

Re: Can you help us change the color on the background of a single value visualization?

niketn — Sat, 29 Dec 2018 17:37:13 GMT

@jip31 the solution I provided should work with state returned as either GOOD or BAD. So you should not be hardcoding the state in your query as mine was just for example. You should ensure that saved search should return the state or you would need to compute the same using the values returned to determine it yourself.

Re: Can you help us change the color on the background of a single value visualization?

jip31 — Mon, 31 Dec 2018 14:38:02 GMT

could you just tell me if what i done is good in my two different panels??
what is strange is that I have "GOOD" in the 2 panels but for one panel GOOD is green and for the other GOOD is grey!!
thanks

 <row>
    <panel>
      <title>Disk Remaining Space Status</title>
      <html depends="$alwaysHideCSSStylePanel$">
       <style>
          #singleWithCSSOverride1 svg.svg-container rect{
             fill: $tokColor1$ !important;
           #singleWithCSSOverride2 svg.svg-container rect{
             fill: $tokColor2$ !important;
           }
        </style>
       </html>
      <single id="singleWithCSSOverride1">
        <title>Good : &gt; 15% - Bad : &lt; 15%</title>
        <search>
          <query>| loadjob savedsearch="admin:FO_Workstations_Monitoring:FO_Workstations_Disk_Size"| eval state="GOOD"</query>
          <earliest>-30d@d</earliest>
          <latest>now</latest>

          <done>
           <eval token="tokColor1">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval>
          </done>


        </search>
        <option name="colorMode">block</option>
        <option name="refresh.display">progressbar</option>
        <option name="useColors">1</option>
      </single>
    </panel>
    <panel>
      <title>Disk Health Status</title>
      <single>
        <title>Good : Status = OK - Bad : Status = Not OK</title>
        <search>
          <query>| loadjob savedsearch="admin:FO_Workstations_Monitoring:FO_Workstations_Disk_Status" | eval state="BAD"</query>
          <earliest>-30d@d</earliest>
          <latest>now</latest>
          <done>
            <eval token="tokColor2">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval>
           </done>

        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="rangeColors">["0x555","0x555"]</option>
        <option name="rangeValues">[0]</option>
        <option name="useColors">1</option>
      </single>
    </panel>
  </row>

Re: Can you help us change the color on the background of a single value visualization?

jip31 — Thu, 03 Jan 2019 10:13:24 GMT

nobody cant help me please??

Re: Can you help us change the color on the background of a single value visualization?

jip31 — Mon, 07 Jan 2019 12:00:17 GMT

I apply your code but I dont understand why I have 2 different colors in two different panels even if the value is "GOOD"
You can see the screen shot here
https://cjoint.com/c/IAhl7mQwPQc

and the xml here

<panel>
      <title>Disk Remaining Space Status</title>
      <html depends="$alwaysHideCSSStylePanel$">
       <style>
          #singleWithCSSOverride1 svg.svg-container rect{
             fill: $tokColor1$ !important;
           #singleWithCSSOverride2 svg.svg-container rect{
             fill: $tokColor2$ !important;
           }
        </style>
       </html>
      <single id="singleWithCSSOverride1">
        <title>Good : &gt; 15% - Bad : &lt; 15%</title>
        <search>
          <query>| loadjob savedsearch="admin:FO_Workstations_Monitoring:FO_Workstations_Disk_Size" 
| search host="$tok_filterhost$" 
| fields - host 
| eval state="GOOD"
</query>
          <earliest>-30d@d</earliest>
          <latest>now</latest>

          <done>
            <eval token="tokColor1">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval>
           </done>


        </search>
        <option name="colorMode">block</option>
        <option name="refresh.display">progressbar</option>
        <option name="useColors">1</option>
      </single>
    </panel>
    <panel>
      <title>Disk Health Status</title>
      <single>
        <title>Good : Status = OK - Bad : Status = Not OK</title>
        <search>
          <query>| loadjob savedsearch="admin:FO_Workstations_Monitoring:FO_Workstations_Disk_Status" 
| search host="$tok_filterhost$" 
| fields - host
| eval state="BAD"
</query>
          <earliest>-30d@d</earliest>
          <latest>now</latest>

          <done>
             <eval token="tokColor2">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval>
            </done>

        </search>

Re: Can you help us change the color on the background of a single value visualization?

askkawalkar — Mon, 07 Jan 2019 12:45:59 GMT

Hi @jip31 ,

In Code you have used 2 different panel and single.

Below changes required :

Use CSS code in both Panel.
Give "id" to second panel single tag.

NOTE: Make sure you are using different token name in eval tag. If token name in eval match with other panel token then there are changes of wrong color coding.

Token will be set by last visualization, last eval tag.

 <done>
            <eval token="tokColor2">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval>
          </done>

Please find below changed code :

<dashboard>
  <label>Single Value Color By Rangemap</label>
  <row>
    <panel>
      <title>Disk Remaining Space Status</title>
      <html depends="$alwaysHideCSSStylePanel$">
        <style>
           #singleWithCSSOverride1 svg.svg-container rect{
              fill: $tokColor1$ !important;
            }
         </style>
        </html>
      <single id="singleWithCSSOverride1">
        <title>Good : &gt; 15% - Bad : &lt; 15%</title>
        <search>
          <done>
            <eval token="tokColor1">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval>
          </done>
          <query>| loadjob savedsearch="admin:FO_Workstations_Monitoring:FO_Workstations_Disk_Size" 
 | search host="$tok_filterhost$" 
 | fields - host 
 | eval state="GOOD"</query>
          <earliest>-30d@d</earliest>
          <latest>now</latest>
        </search>
        <option name="colorMode">block</option>
        <option name="rangeColors">["0x53a051","0x0877a6","0xf8be34","0xf1813f","0xdc4e41"]</option>
        <option name="refresh.display">progressbar</option>
        <option name="useColors">1</option>
      </single>
    </panel>
    <panel>
      <title>Disk Health Status</title>
      <html depends="$alwaysHideCSSStylePanel$">
        <style>
            #singleWithCSSOverride2 svg.svg-container rect{
              fill: $tokColor2$ !important;
            }
         </style>
        </html>
      <single id="singleWithCSSOverride2">
        <title>Good : Status = OK - Bad : Status = Not OK</title>
        <search>
          <done>
            <eval token="tokColor2">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval>
          </done>
          <query>| loadjob savedsearch="admin:FO_Workstations_Monitoring:FO_Workstations_Disk_Status" 
 | search host="$tok_filterhost$" 
 | fields - host
 | eval state="BAD"</query>
          <earliest>-30d@d</earliest>
          <latest>now</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="rangeColors">["0x555","0x555"]</option>
        <option name="rangeValues">[0]</option>
        <option name="refresh.display">progressbar</option>
        <option name="useColors">1</option>
      </single>
    </panel>
  </row>
</dashboard>

Re: Can you help us change the color on the background of a single value visualization?

jip31 — Mon, 07 Jan 2019 14:12:43 GMT

I have made the changes you gave me but same problem even if i use different token names!!

<form>
  <label>Hard Disk</label>
  <description>Specific workstation monitoring - Disk health checking - Slot time : 30 days</description>......<fieldset submitButton="true">
    <input type="text" searchWhenChanged="true" token="tok_filterhost">
      <label>HostName</label>
      <default>*</default>
    </input>
  </fieldset>
  ...
  <row depends="$alwaysHideCSSPanel$">
    <panel>
      <html>
              <style>
                  .dashboard-header p.description {
                       font-size: 16px;
                       font-weight: bold;
                       font-family: Arial;
                       font-style: italic;
                       color: black;
                       padding-top: 40px;
                   }
               </style>
            </html>
    </panel>
  </row>
  <row>
    <panel>
      <title>Disk Remaining Space Status</title>
<html depends="$alwaysHideCSSStylePanel$">
         <style>
            #singleWithCSSOverride1 svg.svg-container rect{
               fill: $tokColor1$ !important;
             }
          </style>
         </html>
       <single id="singleWithCSSOverride1">
         <title>Good : &gt; 15% - Bad : &lt; 15%</title>
         <search>
           <done>
             <eval token="tokColor1">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval>
           </done>
           <query>| loadjob savedsearch="admin:FO_Workstations_Monitoring:FO_Workstations_Disk_Size" 
  | search host="$tok_filterhost$" 
  | fields - host 
  | eval state="GOOD"</query>
           <earliest>-30d@d</earliest>
           <latest>now</latest>
         </search>
         <option name="colorMode">block</option>
         <option name="rangeColors">["0x53a051","0x0877a6","0xf8be34","0xf1813f","0xdc4e41"]</option>
         <option name="refresh.display">progressbar</option>
         <option name="useColors">1</option>
       </single>
     </panel>


    <panel>
      <title>Disk Health Status</title>




       <html depends="$alwaysHideCSSStylePanel$">
         <style>
             #singleWithCSSOverride2 svg.svg-container rect{
               fill: $tokColor2$ !important;
             }
          </style>
         </html>
       <single id="singleWithCSSOverride2">
         <title>Good : Status = OK - Bad : Status = Not OK</title>
         <search>
           <done>
             <eval token="tokColor2">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval>
           </done>
           <query>| loadjob savedsearch="admin:FO_Workstations_Monitoring:FO_Workstations_Disk_Status" 
  | search host="$tok_filterhost$" 
  | fields - host
  | eval state="BAD"</query>
           <earliest>-30d@d</earliest>
           <latest>now</latest>
         </search>
         <option name="colorBy">value</option>
         <option name="colorMode">block</option>
         <option name="rangeColors">["0x555","0x555"]</option>
         <option name="rangeValues">[0]</option>
         <option name="refresh.display">progressbar</option>
         <option name="useColors">1</option>
       </single>
     </panel>
   </row>







  <row>
    <panel>
      <title>Disk Remaining Space Status Details</title>
      <table>
        <search>
          <query>| loadjob savedsearch="admin:FO_Workstations_Monitoring:FO_Workstations_Disk_Size_Details" 
| search host=$tok_filterhost$</query>
          <earliest>-30d@d</earliest>
          <latest>now</latest>
        </search>
        <option name="count">10</option>
        <option name="drilldown">row</option>
        <option name="refresh.display">progressbar</option>
      </table>
    </panel>
    <panel>
      <title>Disk Health Status Details</title>
      <table>
        <search>
          <query>| loadjob savedsearch="admin:FO_Workstations_Monitoring:FO_Workstations_Disk_Status_Details" 
| search host=$tok_filterhost$</query>
          <earliest>-30d@d</earliest>
          <latest>now</latest>
        </search>
        <option name="count">10</option>
        <option name="drilldown">row</option>
        <option name="refresh.display">progressbar</option>
        <option name="rowNumbers">false</option>
        <format type="color" field="Status">
          <colorPalette type="map">{"OK":#3863A0}</colorPalette>
        </format>
      </table>
    </panel>
  </row>
</form>

Re: Can you help us change the color on the background of a single value visualization?

niketn — Mon, 07 Jan 2019 17:59:30 GMT

@jip31. Have you ensured that all the <option> settings in the <single> value panel 1 is same as single value panel2?

If so, open Browser Inspector by Right Clicking the Grey Rectangle of single value panel not working. See whether the CSS override for second one shows up or not. Refer to following older answer of mine to see how to use Browser Inspector: https://answers.splunk.com/answers/590387/how-do-i-update-panel-color-in-splunk-using-css-1.html

Re: Can you help us change the color on the background of a single value visualization?

niketn — Mon, 07 Jan 2019 18:04:40 GMT

@jip31 I modified your <single> panels with run anywhere search with One Good and one Bad result and it worked fine for me

   <row>
     <panel>
       <title>Disk Remaining Space Status</title>
 <html depends="$alwaysHideCSSStylePanel$">
          <style>
             #singleWithCSSOverride1 svg.svg-container rect{
                fill: $tokColor1$ !important;
              }
              #singleWithCSSOverride2 svg.svg-container rect{
                fill: $tokColor2$ !important;
              }
           </style>
          </html>
        <single id="singleWithCSSOverride1">
          <title>Good : &gt; 15% - Bad : &lt; 15%</title>
          <search>
            <done>
              <eval token="tokColor1">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval>
            </done>
            <query>| makeresults
   | eval state="GOOD"</query>
            <earliest>-30d@d</earliest>
            <latest>now</latest>
          </search>
          <option name="colorMode">block</option>
          <option name="rangeColors">["0x53a051","0x0877a6","0xf8be34","0xf1813f","0xdc4e41"]</option>
          <option name="refresh.display">progressbar</option>
          <option name="useColors">1</option>
        </single>
     </panel>
     <panel>
       <title>Disk Health Status</title>
        <html depends="$alwaysHideCSSStylePanel$">
          </html>
        <single id="singleWithCSSOverride2">
          <title>Good : Status = OK - Bad : Status = Not OK</title>
          <search>
            <done>
              <eval token="tokColor2">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval>
            </done>
            <query>| makeresults
   | eval state="BAD"</query>
            <earliest>-30d@d</earliest>
            <latest>now</latest>
          </search>
          <option name="colorBy">value</option>
          <option name="colorMode">block</option>
          <option name="rangeColors">["0x555","0x555"]</option>
          <option name="rangeValues">[0]</option>
          <option name="refresh.display">progressbar</option>
          <option name="useColors">1</option>
        </single>
      </panel>
    </row>

Re: Can you help us change the color on the background of a single value visualization?

askkawalkar — Tue, 08 Jan 2019 04:41:00 GMT

Hi @jip31 ,
I have checked the dashboard color coding using anywherre search, it was working correctly.

Please try changing your query to, hopefully it will work.

| loadjob savedsearch="admin:FO_Workstations_Monitoring:FO_Workstations_Disk_Status" 
   | search host="$tok_filterhost$" 
   | fields - host
   | eval state="BAD"
   | dedup state
   | table state

Re: Can you help us change the color on the background of a single value visualization?

paramagurukarth — Tue, 08 Jan 2019 06:53:22 GMT

Add a new field to the table that represents your desired background color and set that using CSS like below

<dashboard>
  <label>test_back</label>
  <row>
    <panel id="my_pannel">
      <single>
        <search>
          <query>index=*| eval Status=if(Status="OK", "GOOD", "BAD") | eval background=if(Status="OK", "green", "red")  | table Status, background</query>
          <earliest>0</earliest>
          <finalized>
            <set token="background">$result.background$</set>
          </finalized>
          <latest></latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">none</option>
        <option name="drilldown">none</option>
        <option name="numberPrecision">0</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="unitPosition">after</option>
        <option name="useColors">0</option>
        <option name="useThousandSeparators">1</option>
      </single>
    </panel>
  </row>
  <row id="hidden_row">
    <panel>
      <html>
        <style>
          #hidden_row{
            display:none !important;
          }
          #my_pannel .single-value svg.svg-container {
            background:$background$;
          }
        </style>
      </html>
    </panel>
  </row>
</dashboard>

Re: Can you help us change the color on the background of a single value visualization?

jip31 — Tue, 29 Sep 2020 22:36:04 GMT

If I do what you propose : | makeresults
| eval state="GOOD" my query loadjob savedsearch="admin:FO_Workstations_Monitoring:FO_Workstations_Disk_Size" is deleted
You are right my color option settings was a little different
I have modified it
Now I have the same color for the 2 panels but it's grey color....

Re: Can you help us change the color on the background of a single value visualization?

jip31 — Tue, 08 Jan 2019 07:10:39 GMT

HI it changes anything for me!
I am despited

Re: Can you help us change the color on the background of a single value visualization?

jip31 — Wed, 09 Jan 2019 09:36:01 GMT

yes the option settings are the same
you can have a look at the screenshot
https://cjoint.com/c/IAjjGf3JS6d
and there is no issue in the browser inspector....
I dont understand anything

Re: Can you help us change the color on the background of a single value visualization?

niketn — Thu, 10 Jan 2019 12:43:20 GMT

@jip31 if you edit Single Value panel from UI then simple XML token override gets removed. So it is either one of them that you can use.

Also, since Simple XML JS Extension or installing Status Indicator Apps are out of picture for your, all I can help you with is that you can try the with following search:

1) Run your search with loadjob as independent searches instead of running inside single value panel. Use Search Event Handler to set token for State and Color for respective load job query.
2) Create single value panel with result of State and use CSS Color override.

This way Single Value panel will load only after CSS is applied. Make sure you do not have code like the following under single value visualization:

       <option name="rangeColors">["0x555","0x555"]</option>
       <option name="rangeValues">[0]</option>


<form>
  <label>Single Value Color</label>
  <!-- Independent Search to get State from Search 1-->
  <search>
    <query>| loadjob savedsearch="admin:FO_Workstations_Monitoring:FO_Workstations_Disk_Size" 
             | search host="$tok_filterhost$" 
             | fields - host 
             | eval state="GOOD"
     </query>
    <earliest>-30d@d</earliest>
    <latest>now</latest>
    <done>
      <eval token="tokState1">$result.state$</eval>
      <eval token="tokColor1">case($result.state$=="GOOD","#53a051",true(),"#dc4e41")</eval>
    </done>
  </search>
  <row>
    <panel>
      <title>Disk Remaining Space Status $tokState1$ $tokColor1$</title>
     <html depends="$alwaysHideCSSStylePanel$">
      <style>
         #singleWithCSSOverride1 svg.svg-container rect{
            fill: $tokColor1$ !important;
          #singleWithCSSOverride2 svg.svg-container rect{
            fill: $tokColor2$ !important;
          }
       </style>
      </html>
      <single id="singleWithCSSOverride1">
        <title>Good : &gt; 15% - Bad : &lt; 15%</title>
        <search>
          <query>| makeresults
             | fields - _time, "$tokColor1$"
             | eval state="$tokState1$"
           </query>
        </search>
        <option name="colorMode">block</option>
        <option name="refresh.display">progressbar</option>
        <option name="useColors">1</option>
      </single>
    </panel>
  </row>
</form>