Drilldown from dashboard visualization charts into more granular charts for RCA

[jayannah]

Is your feature request related to a problem? Please describe.
Enabling Drilldown support on dashboards will help SRE team to troubleshoot the issues faster. Upon click on visual charts, there should be support to capture the values of click button and pass those values for another hidden query that uses these values as inputs into the query, executes and put the return values(as a chart or as raw input depending the user query).

A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]
If we are unable to drilldown to find the subset data from the dashboard, then every user has to write the query and run..

Describe the solution you'd like

A clear and concise description of what you want to happen.

From Visualization chart, say if the chart is pie chart that has number of each fruit.. Say Apple 10000, Orange 20000, Pears 15000. Now I click on Apple, the value of apple should be passed to the hidden query which will return count of each varieties of apples and display as chart as per use configured. Now if user clicks on orange, the same should happen to pass the orange as the value to next/hidden query and returns count of each varieties of orange.

Splunk supports this feature. Please refer to it to understand. https://docs.splunk.com/Documentation/Splunk/9.2.0/Viz/DrilldownIntro

Describe alternatives you've considered

A clear and concise description of any alternative solutions or features you've considered.
Manually run each and every query and waste lot of time. Also users has to expert in writing query. Without drilldown once developer creates it, anyone can use it for RCAs just with mouse clicks.

Additional context

Add any other context or screenshots about the feature request here.