topic Re: drilldown from single value element to a table in Dashboards & Visualizations

drilldown from single value element to a table

vikas_gopal — Mon, 28 Sep 2020 15:54:29 GMT

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.

count of users with > 10 jobs Pending query
|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

Re: drilldown from single value element to a table

somesoni2 — Mon, 17 Feb 2014 17:27:20 GMT

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

Re: drilldown from single value element to a table

vikas_gopal — Mon, 17 Feb 2014 17:32:16 GMT

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...

Re: drilldown from single value element to a table

emaccaferri — Tue, 18 Feb 2014 14:36:47 GMT

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

Re: drilldown from single value element to a table

vikas_gopal — Tue, 18 Feb 2014 15:17:23 GMT

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.

Re: drilldown from single value element to a table

vikas_gopal — Mon, 28 Sep 2020 15:55:12 GMT

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

Total Pending Standard Concurrent title> <searchstring>| dbquery "Finance Database" limit=1000 "select count(request_id) "count" FROM apps.fnd_concurrent_worker_requests" </searchstring> <earliesttime>-60m@m</earliesttime> <latesttime>now</latesttime> Total result true standard_concurrent_manager_pending_limit_30 range

Re: drilldown from single value element to a table

Ishaan — Thu, 27 Apr 2017 19:39:15 GMT

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,