scale color with value in %

[jip31]

Hi

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??

[Sukisen1981 · Accepted solution]

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

[jip31]

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

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

cell

[Sukisen1981]

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?

[jip31]

Thank you.