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

[tomapatan]

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.

[tomapatan · Accepted solution]

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

[SanjayReddy]

hi @tomapatan 

from the code it should work fine

can you share the drilldown code to check furthur