How to add percentage in unstacked bar chart?

[ritupatil02]

I have a bar chart as shown below. I want to display the percentage of Error, Warn and Info as single value visualisation as another panel. How can I do that?

The query for bar chart panel is:

| stats count by lvl | transpose header_field=lvl column_name=lvl

[kamlesh_vaghela]

@ritupatil02 

Can you please try this?

| stats count by lvl  
| eventstats sum(count) as Total | eval perc=round(count*100/Total,2)
| xyseries count lvl  perc

Thanks
KV
▄︻̷̿┻̿═━一

If any of my reply helps you to solve the problem Or gain knowledge, an upvote would be appreciated. 

[ITWhisperer · Accepted solution]

| stats count by lvl 
| eventstats sum(count) as total
| eval count=100*count/total
| fields - total
| transpose header_field=lvl column_name=lvl
| fields - lvl

Then set visualisation to single trellis mode - you may want to change the number format precision to something other than integers

[ritupatil02]

What if I want 3 different single value panels for Error, Info and Warn resp. Is that possible?

[kamlesh_vaghela]

@ritupatil02  

Like this? 

[ritupatil02]

No. Instead of using trellis, can we have the 3 percentages in 3 different single value panels

[ritupatil02]

Hey that worked.. Thankyou!