Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Splunk Search
×
Are you a member of the Splunk Community?
Sign in or Register with your Splunk account to get your questions answered, access valuable resources and connect with experts!
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- Insert % sign for each result in a specific column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hagjos43
Contributor
05-01-2014
09:52 AM
Current search results are in a table form such as the following:
Search String | Search Engine | Visits | Percent
Document123 | Google | 25 | 9.0123
ABC123 | Yahoo | 21 | 8.7501
HelloWorld | Bing | 2 | 1.0201
I'm attempting to have it displayed as the following:
Search String | Search Engine | Visits | Percent
Document123 | Google | 25 | 9.0123%
ABC123 | Yahoo | 21 | 8.7501%
HelloWorld | Bing | 2 | 1.0201%
Thanks in advance!
Joe
1 Solution
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
gfreitas
Builder
05-01-2014
10:06 AM
Hi Joe,
You can simply do that:
| eval Percent = Percent + " %"
Hope this helps!!
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
lguinn2
Legend
05-01-2014
10:08 AM
At the end of your search, add
| fieldformat Percent=tostring(Percent) + "%"
That should do it!
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
demkic
Explorer
11-02-2016
12:19 PM
Is it possible to also round to two decimal places in addition to adding the % at the end of the search?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
demkic
Explorer
11-02-2016
12:43 PM
It's ok, I figured it out with the round(x,y) command.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
gfreitas
Builder
05-01-2014
10:06 AM
Hi Joe,
You can simply do that:
| eval Percent = Percent + " %"
Hope this helps!!
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hagjos43
Contributor
05-01-2014
10:12 AM
Perfect!!!
Get Updates on the Splunk Community!
Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...
If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...
Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions
Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...
Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...
Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...
