Dashboards & Visualizations

scale color with value in %

jip31
Motivator

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

Tags (1)
0 Karma
1 Solution

Sukisen1981
Champion

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

View solution in original post

0 Karma

Sukisen1981
Champion

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

0 Karma

jip31
Motivator

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



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

cell



0 Karma

Sukisen1981
Champion

Hmmm there is a problem then :slightly_smiling_face:
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?

0 Karma

jip31
Motivator

Thank you.

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...