Dashboards & Visualizations

dynamic token based drilldown in chart using a BY clause

JWBailey
Communicator

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

0 Karma
1 Solution

niketn
Legend

@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

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"

View solution in original post

0 Karma

niketn
Legend

@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

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

JWBailey
Communicator

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

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

This puzzle (first published here) is based on matching timestamps to cron expressions.All the timestamps ...