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
| 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
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.
| 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
What if I want 3 different single value panels for Error, Info and Warn resp. Is that possible?
No. Instead of using trellis, can we have the 3 percentages in 3 different single value panels