Dashboards & Visualizations

drilldown for singlevalue

rakesh_498115
Motivator

Hi All

Can we Drilldown the singlevalue chart in to three other singlevalue charts.i.e by the click on the one singlevalue it should further drill down to three other drilldown singlevalue charts.
please help me on this

Thanks.

Tags (2)

sideview
SplunkTrust
SplunkTrust

If you think about it a little differently, it's pretty easy to do with Sideview Utils. Here's an example.

I basically render out the first number, and then I put it next to a Button module. You can use custom CSS to float my HTML module and the button module side by side. I haven't done that here though.

Then when the user clicks on the Button, the other two pieces of information show in the second HTML module.

<module name="Search" layoutPanel="panel_row2_col1" autoRun="True">
  <param name="search">index=_internal source=*metrics.log group="per_sourcetype_thruput" OR group="per_index_thruput" | stats count by series, group</param>
  <param name="earliest">-1h</param>

  <module name="HTML">
    <param name="html"><![CDATA[
    <h3>$results.count$ indexes and sourcetypes</h3>
    ]]></param>
  </module>

  <module name="Button">
    <param name="allowAutoSubmit">False</param>
    <param name="label">see breakdown</param>

    <module name="PostProcess">
      <param name="search">eval foo=1 | chart count over foo by group | fields - foo</param>

      <module name="HTML">
        <param name="html"><![CDATA[
        Sourcetypes: <b>$results[0].per_sourcetype_thruput$</b><br>
        Indexes: <b>$results[0].per_index_thruput$</b><br>
        ]]></param>
      </module>
    </module>
  </module>
</module>

One problem is that the HTML module below the button displays the empty content before the button is clicked...

Moreover though, this use case is just a little odd and maybe I'm missing something. Why not just display both numbers at once, or display all three numbers?

0 Karma

sideview
SplunkTrust
SplunkTrust

OK. Well the approach above would show only the first number until the button was clicked. even easier would be to show the first number in a one-row Table, and then supply all the other information with HTML modules below the Table, when the row was clicked by the user.

0 Karma

Jason
Motivator

They're making a tiered dashboard. Components A, B, and C. Each component has subcomponents 1, 2, and 3 that they want show response times of. So, they show A, B, and C in row 1, then depending on what you click, A1/A2/A3, B1/B2/B3, or C1/C2/C3 should show in row 2. They don't want to show all values for all combinations because it is too much for the user to take in.

0 Karma

araitz
Splunk Employee
Splunk Employee

Unfortunately, SingleValue is only wired to drill down into different views, not provide drilldown parameters for other modules. Is this something that would be useful enough for you that we should consider it for a future enhancement? If so, can you provide some more detail about your use case?

0 Karma

rakesh_498115
Motivator

yeah..Sure..I actually need to display a singlevalue chart that contains the total count of the requests and responses from the logs , and then when i click on this singlevalue it has to be further drilldowned to two other singlevalue boxes which contains requests count and responses count separately.for Example If the above singlevalue BOX1 contains value 100 (both requests and responses count) , when i click on this i need to get BOX2 containing a value 60 ( requests count alone ) and BOX3 containing value 40 (responses count alone ).I Hope given the required information.

0 Karma
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

REGISTER NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If ...

Observability | Use Synthetic Monitoring for Website Metadata Verification

If you are on Splunk Observability Cloud, you may already have Synthetic Monitoringin your observability ...

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...