Dynamic Drilldown view based on selected cell's column header value and corresponding row value(first column)

[NathanAsh]

Hi,

I wish to pass the values of $click.value$ and corresponding cell's header (dynamically generated in splunk query) values to the search query in creating the drilldown view of dashboard. Please let me know how to achieve that.

for example if the user clicks on the cell containing 100.00 value, I need to pass the channel name adp and header value of 304 to the search query 

adp can be achieved through $click.value$ , don't know for 304 (and its corresponding search field name) 

sp.JPG

[NathanAsh]

Thanks for the help. One more clarification. Hope there is no and condition in the search operation. can I try like this

....query| search fieldname="$click.value$" | where fieldname2="$click.name2$"

[ITWhisperer]

You could do that, but whether that makes sense depends on your search, the fields available and your data, which I am not in a position to comment on.

[ITWhisperer · Accepted solution]

$click.name2$ gives you the column (field) name where the user clicked.

$click.name$		$click.name2$
$click.value$		$click.value2$ (user clicked here)