Splunk Search

how to format numbers ina simpleresultstable?

sou128
Explorer

currently my simpletresultstable is showing

myDecimalfield1 | myNumfield1 | MyCalculatedField1

1234.56789 | 1 | 1234.56789 <--- myDecimalfield1 divided by myNumfield1

how can I format myDecimalfield1 and MyCalculatedField1 to show only 2 decimal places? thx

0 Karma
1 Solution

sdaniels
Splunk Employee
Splunk Employee

Use eval with round().

| eval myField = round(myNumField1 ,2)

http://docs.splunk.com/Documentation/Splunk/4.3.2/SearchReference/CommonEvalFunctions

Then is display the new field (myField) in your table.

View solution in original post

sdaniels
Splunk Employee
Splunk Employee

Use eval with round().

| eval myField = round(myNumField1 ,2)

http://docs.splunk.com/Documentation/Splunk/4.3.2/SearchReference/CommonEvalFunctions

Then is display the new field (myField) in your table.

Get Updates on the Splunk Community!

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...