Splunk Search

How to create a total volume label on each pie on a trellis dashboard panel

adamjones
Engager

I'm trying to display allowed vs blocked traffic for several different accounts. I think a trellis chart with a pie representing each account is a good way to display this. However, I want the dashboard to also convey the total volume of traffic for each account.

Here is my search (altered for simplicity/privacy):

index=(index) (more filters)
|(miscellaneous lookups and filters)
| chart count(_raw) over account by action
| addtotals allowed blocked

This gives me a table that looks like this:
alt text

Then that table then gives me a trellis pie chart dash that looks like this:

alt text

What I would like is for the numbers from the "totals" column in the table to populate with each of the corresponding pies as a label or something.

0 Karma

adamjones
Engager

@niketnilay Thank you. Its really close. The total is showing up, so that's awesome! For some reason when it's painting the pie it shows the allowed and blocked numbers, but its charting it by percentage of blocked compared to blocked so all the pies are showing up as 100% full. I've been tweaking it trying to make it work, but I cant quite get it. I tried messing with the chart settings, but there's not much there.

Any ideas?

alt text

0 Karma

niketn
Legend

@adamjones try the following search and confirm. The total should display along with Account Names.

  index=(index) (more filters)
 | (miscellaneous lookups and filters)
 | chart count by account action
 | addtotals allowed blocked
 | eval account=account." (".Total.")"
 | stats sum(allowed) as allowed  sum(blocked) as blocked by account
____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...