Dashboards & Visualizations

How to get pie chart drilldown to show only the daily or only the nightly statistics?

tomapatan
Communicator

Hi Everyone,

I have 3 pie charts in a panel, showing agent statistics as follows:

- 1st pie chart displays overall statistics split by analyst;

- 2nd pie chart displays daily statistics split by analyst ( | where shift="Day")

- 3rd pie chart displays nightly statistics split by analyst ( | where shift="Night").

I've created a drilldown which works fine for the overall pie chart and it correctly displays the data in another panel based on the value of the slice.  To accomplish this I`ve created a token called "tokNames" and assigned an initial value of ALL *.

<init>
<set token="tokNames">*</set>
</init>

Drilldown for the Overall pie chart:

<drilldown>
<set token="tokNames">$click.value$</set>
</drilldown>

The problem starts with the daily and nightly pie charts - when I click on a name, it displays all the statistics of that particular agent, instead of showing only the daily or only the nightly statistics.

Any assistance would be greatly appreciated.

Thank you in advance.

Toma.

Labels (1)
0 Karma
1 Solution

tomapatan
Communicator

Hi All,

The solution was very simple, I had to create another static token="tokShift" and edit the drilldown as follows:

- for the overall pie chart: "tokShift"=*

- for the day pie chart: "tokShift"=Day

for the night pie chart: "tokShift"=Night

Also had to pass the token to the table panel: | search agent="$tokNames$" shift="$tokShift$"

Regards,

Toma

View solution in original post

0 Karma

tomapatan
Communicator

Hi All,

The solution was very simple, I had to create another static token="tokShift" and edit the drilldown as follows:

- for the overall pie chart: "tokShift"=*

- for the day pie chart: "tokShift"=Day

for the night pie chart: "tokShift"=Night

Also had to pass the token to the table panel: | search agent="$tokNames$" shift="$tokShift$"

Regards,

Toma

0 Karma

SanjayReddy
SplunkTrust
SplunkTrust

hi @tomapatan 

from the code it should work fine

can you share the drilldown code to check furthur

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 ...