Refine your search:

I have a data table panel on a dashboard withthe following search:

sourcetype="PubsCounts-too_small" * |fields account received, authorized, Difference |eval Difference= (authorized-received) | chart values(Difference) as Difference by account

It displays well except that I would like to have a heatmap on the difference column. If I view the results, I can use the heatmap to great effect.

How can I use a heatmap in this search on the dashboard? BTW: It is an inline search.

asked 30 Apr '10, 18:53

kmattern's gravatar image

kmattern
15319
accept rate: 23%


One Answer:

The simplified XML dashboards dont have this ability - you cant do it from the editing UI that you see, nor from editing the simplified XML source.

However the entire simplified XML is just a shortcut layer to the advanced XML syntax. And in the advanced xml this is relatively easy to do.

Converting from the simplified XML to the advanced XML is briefly discussed on this page http://www.splunk.com/base/Documentation/latest/Developer/AdvancedDashboard

however here are the individual steps spelled out:

  1. load your working (simplified XML) view in the browser
  2. tack ?showsource=1 onto the end of the URL
  3. you'll be in a weird page. scroll down. you'll see a huge textarea field full of XML. Copy it into your clipboard
  4. back to your working view.
  5. Actions > edit dashboard
  6. click the little blue link 'Edit name/xml'.
  7. in the form that loads, paste the big nasty advanced xml in there.

converting from a simplified dashboard brings a bunch of weird cruft into the advanced world, but it'll work fine.

Once its converted, getting your heatmap is simply a matter of: finding this line:

<module name="SimpleResultsTable">

and inside that module, ie right under that line, put

  <param name="dataOverlayMode">heatmap</param>
link

answered 01 May '10, 02:02

nick's gravatar image

nick ♦
14.2k1318
accept rate: 47%

Nick,

I'm using 4.0.10 at present and showsource does not give me any XML. What other options do I have to either generate advanced XML or to get the heatmap some other way?

Ken

(10 May '10, 15:36) kmattern

I see. =) Well honestly the path of least resistance is probably to install a copy of 4.1 on your laptop briefly, copy over the simplified XML view, and use its showsource=1 to do the conversion and then copy the result back to your instance.

(10 May '10, 17:05) nick ♦
Post your answer
toggle preview

Follow this question

Log In to enable email subscriptions

RSS:

Answers

Answers + Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×323

Asked: 30 Apr '10, 18:53

Seen: 1,273 times

Last updated: 01 May '10, 02:02

Copyright © 2005-2012 Splunk, Inc. All rights reserved.