My dashboard shows below 3 fields
Department_name, Permanent_Count, Temp_Count
computers, 10,5
electricals, 20,7
mechanical, 15, 10
Now permanent_count and Temp_count are calculated fields which is sum of a field from my input lookup file depending on many criteria like region, band etc.
So if i do a condition match with click.value2 and search for that value say 10 that wont exist in my look up file, since thats a calculated field not a direct one.
Now my requirement is if i click on number 10 in the row computers i should see all the name of employees under computers department .
In your drilldown, you can reference other fields in the same row by using the syntax $row.<fieldname>$
. So for example, you can reference $row.Department_name$
in your drilldown, and pass that token into your drilldown search.
@surekhasplunk, this seems to be a rephrased duplicate of the following question: https://answers.splunk.com/answers/590928/drilldown-cell-value.html
In your drilldown, you can reference other fields in the same row by using the syntax $row.<fieldname>$
. So for example, you can reference $row.Department_name$
in your drilldown, and pass that token into your drilldown search.
Thanks it worked with $row.Department_name$ and also i have added search queries for each field passing this token along with other tokens. And disabling drilldown for few cells.
Thanks