Dashboards & Visualizations

drilldown from single value element to a table

vikas_gopal
Builder

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

Tags (1)
0 Karma
1 Solution

vikas_gopal
Builder

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





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



View solution in original post

0 Karma

Ishaan
New Member

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,

0 Karma

vikas_gopal
Builder

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





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



0 Karma

emaccaferri
Communicator

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

0 Karma

vikas_gopal
Builder

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.

0 Karma

vikas_gopal
Builder

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

0 Karma

somesoni2
SplunkTrust
SplunkTrust

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

Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...