How to add percentages to Bar Charts?

[POR160893]

Hi,

I have a series of bar charts and when I hoover each bar, I currently see the count value.

What I actually need is the percentage value.

Here is my current query and bar chart:

| inputlookup Migration-Status-All.csv
| search Vendor = "Symantec"
| eval dummy = 'Migration Comments'
| chart count over "Migration Comments" by dummy

How can I change my query to show a percentage when hoovering over each bar?


Many thanks,
Patrick

[somesoni2 · Accepted solution]

Give this a try

**UPDATED

| inputlookup Migration-Status-All.csv
| search Vendor = "Symantec"
| stats count by "Migration Comments"
|  eventstats sum(count) as Total
|  eval perc=round(count*100/Total,2)
| eval dummy = 'Migration Comments'
| chart sum(perc) over "Migration Comments" by dummy

[POR160893]

Thanks .... works perfectly (and I gave you Kudos!)

[POR160893]

I get no results for either:

or (changing the per to perc):

[somesoni2]

Try the updated query above.