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!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...