drilldown from single value element to a table

[vikas_gopal]

Hello,

I am preparing a dashboard please suggest how to drilldown from a single value element to a table .I have the follwoing code for single value element after clicking on the value it opens search bar with table.I do not want to show query to the customer so i just need a table no search bar.

|dbquery "Finance Database" limit=1000 "select count(request_id) FROM apps.fnd_concurrent_worker_requests"
Total
result
|dbquery "Finance Database" limit=1000 "select fu.user_name ,count(request_id) FROM apps.fnd_concurrent_worker_requests
range

[Ishaan]

Hello..

can anyone help me How to use Drilldown from a singleValue panel to an another dashboard,
Please help me in detail as I didn't used it before and iam very new to splunk
Highly appreciate for this help.

Thanks,

[vikas_gopal · Accepted solution]

finally issue has been resolved Thanks to emaccaferri and somesoni2 u both provided me some ideas and doc links using that I reached to the follwoing doc
http://docs.splunk.com/Documentation/Splunk/6.0.1/Viz/PanelreferenceforSimplifiedXML#single
Here different options has been mentioned for .So, we can use option along with and to show another view or dashboard.Here is my code

single value Clone

[emaccaferri]

Using the drilldown options you can connect to dashboard. You can find a lot of documentation to start, for example see here
http://docs.splunk.com/Documentation/Splunk/latest/Viz/Dynamicdrilldownindashboardsandforms

[vikas_gopal]

Thanks emaccaferri,
It is absolutely fine with table but i am using value and options like or is not working for .I have checked one example in that they used but with this again search bar appears with the query.

[vikas_gopal]

Thanks for the advice , sure I will try that but need to check how to call another dashboard on click as i am new to splunk...

[somesoni2]

You can create a dashboard which has just the table and drilldown to that dashboard from your single value.