https://community.splunk.com/t5/Splunk-Search/How-to-create-a-drilldown-based-on-the-clicked-row-in-a-stats/m-p/261803#M78599 <P>That was easy, thanks for the fix!</P> Tue, 30 Aug 2016 18:29:23 GMT JoshuaJohn 2016-08-30T18:29:23Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-drilldown-based-on-the-clicked-row-in-a-stats/m-p/261801#M78597 <P>I have this stats table<BR /> <span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/1798i1BBB0EFA9BD52D09/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> <P>This is the search that creates it:</P> <PRE><CODE>index="nitro_application_summary" earliest=-1h@m latest=@m [| `nitro_prod_cmdb` | search Category="*" Service="*" Application="*" | stats count by Application | table Application] | join Application [ | `nitro_prod_cmdb_service_app_relationships` ] | search Alert_Type="*" Metric_Category="*" | eval FilterKey=Description.ID | dedup FilterKey | table Alert_Type Category Service Application Metric_Category Description Key ID| rename Metric_Category as "Type" Alert_Type as "Alert" count as Count | sort +Alert </CODE></PRE> <P>I want it so when I click the row, it grabs the category of the row I am clicking and inserts that into the URL<BR /> This is my drill down in the XML</P> <PRE><CODE> &lt;link&gt; &lt;![CDATA[ /app/nitro_app_summary/nitro_summary_details_view_sideview?Category= (This is where I want whatever is in the category section) ]]&gt; &lt;/link&gt; &lt;/drilldown&gt; </CODE></PRE> <P>Any ideas? I do not want to use drop-downs or any selection tools. I want to be able to just click on the row and for it to open based on the category.</P> Tue, 30 Aug 2016 18:19:41 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-drilldown-based-on-the-clicked-row-in-a-stats/m-p/261801#M78597 JoshuaJohn 2016-08-30T18:19:41Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-drilldown-based-on-the-clicked-row-in-a-stats/m-p/261802#M78598 <P>Try this</P> <PRE><CODE> &lt;link&gt; &lt;![CDATA[ /app/nitro_app_summary/nitro_summary_details_view_sideview?Category=$row.category$ ]]&gt; &lt;/link&gt; &lt;/drilldown&gt; </CODE></PRE> <P><A href="http://docs.splunk.com/Documentation/Splunk/6.4.3/Viz/tokens#Define_tokens_for_dynamic_drilldown">http://docs.splunk.com/Documentation/Splunk/6.4.3/Viz/tokens#Define_tokens_for_dynamic_drilldown</A></P> Tue, 30 Aug 2016 18:24:23 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-drilldown-based-on-the-clicked-row-in-a-stats/m-p/261802#M78598 sundareshr 2016-08-30T18:24:23Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-drilldown-based-on-the-clicked-row-in-a-stats/m-p/261803#M78599 <P>That was easy, thanks for the fix!</P> Tue, 30 Aug 2016 18:29:23 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-drilldown-based-on-the-clicked-row-in-a-stats/m-p/261803#M78599 JoshuaJohn 2016-08-30T18:29:23Z