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!
Aligning Observability Costs with Business Value: Practical Strategies
Join us for an engaging Tech Talk on Aligning Observability Costs with Business Value: Practical ...
Mastering Data Pipelines: Unlocking Value with Splunk
In today's AI-driven world, organizations must balance the challenges of managing the explosion of data with ...
Splunk Up Your Game: Why It's Time to Embrace Python 3.9+ and OpenSSL 3.0
Did you know that for Splunk Enterprise 9.4, Python 3.9 is the default interpreter? This shift is not just a ...
