topic Re: dynamic token based drilldown in chart using a BY clause in Dashboards & Visualizations

dynamic token based drilldown in chart using a BY clause

JWBailey — Tue, 29 Sep 2020 23:28:01 GMT

I have a timechart visualization using a by clause to display two different data sets. I think the number of successful logons and failed logons over time displayed on the same chart...

For example:

action=logon_failure  OR action=logon_success | timechart count by action

I want the timechart to have drilldown capability, so when someone clicks on a portion of the chart, a new panel displays the list of usernames that generate that value in the timechart.

I have no problems creating the "pop up" panel using the depends flag, and no problems setting tokens to grab the earliest and latest time values based on the user's click. But how do I capture which by clause attribute the user clicked? How do I pass the "logon_failure" or "logon_success" value so I can use it to filter the search results that drive the new panel?

Any guidance is appreciated. Thanks in advance.

~Wes

Re: dynamic token based drilldown in chart using a BY clause

niketn — Fri, 01 Mar 2019 09:52:44 GMT

@JWBailey , if you have performed timechart by action you will have logon_failure and logon_success as columns which can be picked by using click.name2 predefined drilldown token. Please try the following and see if $tokAction$ picks the value you are interested in.

<drilldown>
    <set token="tokAction">$click.name2$</set>
</drilldown>

https://docs.splunk.com/Documentation/Splunk/latest/Viz/EventHandlerReference#Drilldown_event_tokens

Re: dynamic token based drilldown in chart using a BY clause

JWBailey — Fri, 01 Mar 2019 13:26:42 GMT

Worked like a charm, thank you. As is so often I was way over complicating it in my attempts.