topic Re: scale color with value in % in Dashboards & Visualizations

scale color with value in %

jip31 — Tue, 29 Sep 2020 23:20:31 GMT

I need to do a scale color on a value in % but nothing happens
my search is
eventtype=Charge
| stats first(FullChargedCapacity) AS FullChargedCapacity first(DesignedCapacity) AS DesignedCapacity first(_time) AS _time BY host
| eval Wear_Rate = 100-(FullChargedCapacity *100/DesignedCapacity)
| where Wear_Rate >5
| eval Wear_Rate=round(Wear_Rate, 1). " %"
| table time host FullChargedCapacity DesignedCapacity Wear_Rate

Could you help me please??

Re: scale color with value in %

Sukisen1981 — Sat, 23 Feb 2019 10:09:25 GMT

hmm is it possible to sort Wear_Rate from smallest o largest?
If yes, then you need to apply this code to your simple xml[#FFFFFF,#006D9C] <scale type="sharedCategory"></scale> </format>

add this just before the closing tag.This is not exact and you do need to add |sort Wear_Rate
Check the output and see how it looks

Re: scale color with value in %

jip31 — Sat, 23 Feb 2019 10:57:33 GMT

I use secheduled reports the code is not in xml....

| loadjob savedsearch="admin:toto:tata"
-30d@d
now

cell

Re: scale color with value in %

Sukisen1981 — Sat, 23 Feb 2019 12:16:25 GMT

Hmmm there is a problem then 🙂
Basically, you can not apply a scale to a string,whether you use eval or fieldformat.
Is a work around possible? Instead of using | eval Wear_Rate=round(Wear_Rate, 1). " %"
can you use something like | eval Wear_Rate_percentage=round(Wear_Rate, 1)
and then you can use the default scale coloring.
So that your column remains a number and you intimate users through the column heading that this is a percentage figure?

Re: scale color with value in %

jip31 — Sat, 23 Feb 2019 15:00:29 GMT

Thank you.