topic Re: Dynamic Drilldown view based on selected cell's column header value and corresponding row value(first column) in Dashboards & Visualizations

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

NathanAsh — Thu, 13 Jul 2023 17:50:33 GMT

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)

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

ITWhisperer — Thu, 13 Jul 2023 18:02:35 GMT

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

$click.name$		$click.name2$

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

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

NathanAsh — Thu, 13 Jul 2023 19:18:43 GMT

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$"

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

ITWhisperer — Fri, 14 Jul 2023 06:59:49 GMT

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.