topic Re: Help using scale colors depending on the value result in Dashboards & Visualizations

Help using scale colors depending on the value result

jip31 — Mon, 01 Jul 2019 12:31:12 GMT

Hello,
Is it possible in the XML below to use scale colors?
If perc result is :

<5% I want to color the value in green
between 5 and 25% I want to color the value in orange
>25% I want to color the value in red

Many thanks

<row id="first">
    <panel>
      <title>Crashes - Volume percentage (%)</title>
      <single id="test">
        <title>Source : Windows Event Viewer (ID 6008) - Slot time : last 30 days</title>
        <search>
          <query>[| inputlookup host.csv 
    | table host] `BSOD` 
| dedup host 
| lookup lookup_cmdb_fo_all.csv HOSTNAME as host output SITE 
| search SITE=$tok_filtersite|s$ 
| stats dc(host) as NbEventCodeHost 
| appendcols 
    [| inputlookup host.csv 
    | lookup lookup_cmdb_fo_all.csv HOSTNAME as host output SITE 
    | search SITE=$tok_filtersite|s$ 
    | stats dc(host) as NbIndHost 
        ] 
| eval Perc=round((NbEventCodeHost/NbIndHost)*100,2). " %" + " / " + NbIndHost + " machines " 
| table Perc</query>
          <earliest>-30d@d</earliest>
          <latest>now</latest>
        </search>
        <option name="colorMode">none</option>
        <option name="drilldown">all</option>
        <option name="rangeColors">["0x65a637","0xd93f3c","0xd93f3c"]</option>
        <option name="rangeValues">[0,1]</option>
        <option name="refresh.display">progressbar</option>
        <option name="useColors">1</option>
      </single>
    </panel>

Re: Help using scale colors depending on the value result

renjith_nair — Mon, 01 Jul 2019 14:26:06 GMT

@jip31,

It's possible but the value has to be numeric.

Try this

<row id="first">
     <panel>
       <title>Crashes - Volume percentage (%)</title>
       <single id="test">
         <title>Source : Windows Event Viewer (ID 6008) - Slot time : last 30 days</title>
         <search>
           <query>[| inputlookup host.csv 
     | table host] `BSOD` 
 | dedup host 
 | lookup lookup_cmdb_fo_all.csv HOSTNAME as host output SITE 
 | search SITE=$tok_filtersite|s$ 
 | stats dc(host) as NbEventCodeHost 
 | appendcols 
     [| inputlookup host.csv 
     | lookup lookup_cmdb_fo_all.csv HOSTNAME as host output SITE 
     | search SITE=$tok_filtersite|s$ 
     | stats dc(host) as NbIndHost 
         ] 
 | eval Perc=round((NbEventCodeHost/NbIndHost)*100,2)
 | table Perc,NbIndHost</query>
           <earliest>-30d@d</earliest>
           <latest>now</latest>
           <done>
                     <set token="NbInd_Token">$result.NbIndHost$</set>
           </done>
         </search>
        <option name="colorMode">block</option>
        <option name="rangeColors">["0x65a637","0xf1813f","0xd93f3c"]</option>
        <option name="rangeValues">[5,25]</option>
        <option name="refresh.display">progressbar</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="unit">%</option>
        <option name="useColors">1</option>
        <option name="underLabel">/ $NbInd_Token$ machines</option>
       </single>
     </panel>

Re: Help using scale colors depending on the value result

jip31 — Tue, 02 Jul 2019 06:00:37 GMT

thanks renjith
last question
why you have deleted : + " / " + NbIndHost + " machines "?
I need to keep this piece of code and to color it in blue
is it possible??

Re: Help using scale colors depending on the value result

renjith_nair — Tue, 02 Jul 2019 10:17:40 GMT

As mentioned above, single value customization works on numeric values. So if you add the strings to that, then the formatting can not be done.
One option is to use under label option and set the value there. I have updated the answer with that option.
If that's not what you are looking for, then you might need to use either the Status Indicator App or css/js solutions

Re: Help using scale colors depending on the value result

jip31 — Tue, 02 Jul 2019 11:35:43 GMT

thanks renjith

Re: Help using scale colors depending on the value result

jip31 — Wed, 03 Jul 2019 07:16:55 GMT

hi
i just have an issue with

/ $NbIndHost$ machines
the token doesnt works (see screenshot)
https://www.cjoint.com/c/IGdhqOOpLLd

have you an idea??

Re: Help using scale colors depending on the value result

renjith_nair — Wed, 03 Jul 2019 13:05:14 GMT

@jip31,

As mentioned in the above XML, have you added this part in search tag?

   <latest>now</latest>
            <done>
                      <set token="NbIndHost">$result.NbIndHost$</set>
            </done>
          </search>

Re: Help using scale colors depending on the value result

jip31 — Wed, 30 Sep 2020 01:14:02 GMT

Yes
you can see my xml

TEST

TEST

Re: Help using scale colors depending on the value result

renjith_nair — Wed, 03 Jul 2019 14:11:29 GMT

Not able to see the xml. can you put them in code to avoid the xml truncate?

Re: Help using scale colors depending on the value result

jip31 — Thu, 04 Jul 2019 05:50:28 GMT

<panel>
      <title>TEST</title>
      <single>
        <title>TEST</title>
        <search>
          <query>[| inputlookup host.csv 
    | table host] index="ai-wkst-wineventlog-fr" sourcetype=XmlWinEventLog source="XmlWinEventLog:System" EventCode=* (Level=1 OR Level=2 OR Level=3) 
| dedup host 
| lookup lookup_cmdb_fo_all.csv HOSTNAME as host output SITE 
| search SITE=$tok_filtersite|s$ 
| stats dc(host) as NbEventCodeHost 
| appendcols 
    [| inputlookup host.csv 
    | lookup lookup_cmdb_fo_all.csv HOSTNAME as host output SITE 
    | search SITE=$tok_filtersite|s$ 
    | stats dc(host) as NbIndHost 
        ] 
| eval Perc=round((NbEventCodeHost/NbIndHost)*100,2)
| table Perc</query>
          <earliest>-30d@d</earliest>
          <latest>now</latest><done>
                       <set token="NbIndHost">$result.NbIndHost$</set>
             </done>
        </search>
        <option name="colorMode">block</option>
        <option name="rangeColors">["0x65a637","0xf1813f","0xd93f3c"]</option>
        <option name="rangeValues">[5,25]</option>
        <option name="refresh.display">progressbar</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="unit">%</option>
        <option name="useColors">1</option>
        <option name="underLabel">/ $NbIndHost$ machines</option>
      </single>
    </panel>

Re: Help using scale colors depending on the value result

jip31 — Thu, 04 Jul 2019 05:50:44 GMT

HERE IS THE CODE

Re: Help using scale colors depending on the value result

renjith_nair — Thu, 04 Jul 2019 08:50:30 GMT

"You dont need to use Capital letters , "just saying"

in your search , you missed to add NbIndHost with the table command which is in the actual XML I pasted

i.e.

    | table Perc,NbIndHost

Re: Help using scale colors depending on the value result

jip31 — Thu, 04 Jul 2019 09:38:31 GMT

oh sorry its exact
I didnt see that you added this in table
thanks

Re: Help using scale colors depending on the value result

jip31 — Thu, 04 Jul 2019 11:25:41 GMT

But I found a second issue

$result.NbIndHost$ is linked to a dropdown list like you can see in `| search SITE=$tok_filtersite|s$ `

but when I am doing a choice in | search SITE=$tok_filtersite|s$ the result in $result.NbIndHost$ doesnt change
Have you an idea please??

Re: Help using scale colors depending on the value result

renjith_nair — Thu, 04 Jul 2019 13:06:50 GMT

Updated the answer to change the token name just to avoid confusions

token name has been changed from NbIndHost to NbInd_Token

Regarding your question, when you change the token , does the value under the field NbIndHost change? You can view that by opening the search

Re: Help using scale colors depending on the value result

jip31 — Thu, 04 Jul 2019 13:42:49 GMT

like this is correct!

Re: Help using scale colors depending on the value result

renjith_nair — Sat, 06 Jul 2019 05:37:24 GMT

is it working for you or do you have still issues?

Re: Help using scale colors depending on the value result

jip31 — Sun, 07 Jul 2019 14:53:27 GMT

its ok thanks!