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!

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...

March Community Office Hours Security Series Uncovered!

Hello Splunk Community! In March, Splunk Community Office Hours spotlighted our fabulous Splunk Threat ...

Stay Connected: Your Guide to April Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars in April. This post ...