topic Re: drilldown for singlevalue in Dashboards & Visualizations

drilldown for singlevalue

rakesh_498115 — Thu, 17 May 2012 09:32:19 GMT

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.

Re: drilldown for singlevalue

araitz — Thu, 17 May 2012 20:56:26 GMT

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?

Re: drilldown for singlevalue

rakesh_498115 — Sun, 20 May 2012 07:04:53 GMT

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.

Re: drilldown for singlevalue

sideview — Tue, 22 May 2012 18:56:28 GMT

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?

Re: drilldown for singlevalue

Jason — Fri, 08 Mar 2013 10:14:21 GMT

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.

Re: drilldown for singlevalue

sideview — Fri, 08 Mar 2013 18:18:21 GMT

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.