topic Re: Show all values 0 to 100 with precision up to 2 decimal points in Splunk Search

Show all values 0 to 100 with precision up to 2 decimal points

barunbiswas — Wed, 20 Sep 2017 06:22:34 GMT

I am working on a single value dashboard panel where I am showing output in percentage with precision up to 2 decimal points (e.g. 60.25%). However, I want shows 0 and 100 as a whole number (NO decimal point precision for these two). Please advise whether it is possible.

Re: Show all values 0 to 100 with precision up to 2 decimal points

Sukisen1981 — Wed, 20 Sep 2017 06:40:58 GMT

why not just round off the single value field to 0 decimal places?

Re: Show all values 0 to 100 with precision up to 2 decimal points

barunbiswas — Wed, 20 Sep 2017 08:11:01 GMT

I think I should have been more clear with my question. I want to show all values except 0 & 100 with precision up to 2 decimal points (e.g. 60.25%); and I want to show 0 & 100 as a whole number. Any advice on this please.

Re: Show all values 0 to 100 with precision up to 2 decimal points

Sukisen1981 — Wed, 20 Sep 2017 09:52:17 GMT

Hi,

Try this, assuming X is your single value field :
| eval x=if(floor(x)=x,floor(x),x)
| where x!=0
| eval x=x." %"
| fields _time,x

Based and checked my solution on this excellent entry - https://answers.splunk.com/answers/443308/how-to-round-values-to-2-decimal-places-but-only-f.html
Checked for 0 and with decimal, the solution works.
Set your number format to 0.00 in the single value visualization

Re: Show all values 0 to 100 with precision up to 2 decimal points

cmerriman — Wed, 20 Sep 2017 11:52:06 GMT

i think this might work for you, you'll have to code it into the SPL, not the formatting.

...|eval interestingField=if(numerator/denominator*100=0 OR numerator/denominator*100=100, numerator/denominator*100, round(numerator/denominator*100,2))

Re: Show all values 0 to 100 with precision up to 2 decimal points

barunbiswas — Thu, 21 Sep 2017 08:46:15 GMT

Thanks for your reply. However, it is not working in the dashboard.

Re: Show all values 0 to 100 with precision up to 2 decimal points

Sukisen1981 — Thu, 21 Sep 2017 08:59:13 GMT

can you be more specific? what is no working? no values or the decimal?

Re: Show all values 0 to 100 with precision up to 2 decimal points

barunbiswas — Fri, 22 Sep 2017 09:39:21 GMT

In dashboard, it is showing all values in 0.00 format. I think that single value visualization format is taking precedence over the spl?

Re: Show all values 0 to 100 with precision up to 2 decimal points

Sukisen1981 — Sat, 23 Sep 2017 09:40:39 GMT

if you dont save it in the dashboard and just run the search and see the visualization tab, is that working?