Insert % sign for each result in a specific column

[hagjos43]

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

[lguinn2]

At the end of your search, add

| fieldformat Percent=tostring(Percent) + "%"

That should do it!

[demkic]

Is it possible to also round to two decimal places in addition to adding the % at the end of the search?

[demkic]

It's ok, I figured it out with the round(x,y) command.

[gfreitas · Accepted solution]

Hi Joe,

You can simply do that:

| eval Percent = Percent + " %"

Hope this helps!!

[hagjos43]

Perfect!!!