Dashboards & Visualizations

How to make a header to a drilldown table?

iKate
Builder

I've added to a dashboard a drilldown table that appears after clicking any piece of stacked columns in a timechart. For this purpose the module ConvertToDrilldownSearch was used. The timechart shows dayly dynamics of the function "item".

Is it possible to add a header to the table that can show what data is represented? For example: "Purchases dynamics for the on <07/01/2012>"

Tags (2)
1 Solution

sideview
SplunkTrust
SplunkTrust

Sure. You can use a SimpleResultsHeader module. SimpleResultsHeader's 'headerFormat' param is one of the few core Splunk module params that can display $foo$ tokens from other selected elements upstream.

However note that if it's the split-by field value of a stacked timechart, you'll need $click.name2$ to get the split-by value, not $click.value$.

So here you go:

<module name="SimpleResultsHeader">
  <param name="entityName">results</param>
  <param name="headerFormat">Purchase dynamics for $click.name2$ $time$</param>
</module>

As a side note if you're already using Sideview Utils it's very similar but you would just use an HTML module, and the $time$ key becomes $search.timeRange.label$. It would then look like this.

<module name="HTML">
  <param name="html"><![CDATA[
    <h2>Purchase dynamics for $click.name2$ $search.timeRange.label$</h2>
  ]]></param>
</module>

View solution in original post

0 Karma

sideview
SplunkTrust
SplunkTrust

Sure. You can use a SimpleResultsHeader module. SimpleResultsHeader's 'headerFormat' param is one of the few core Splunk module params that can display $foo$ tokens from other selected elements upstream.

However note that if it's the split-by field value of a stacked timechart, you'll need $click.name2$ to get the split-by value, not $click.value$.

So here you go:

<module name="SimpleResultsHeader">
  <param name="entityName">results</param>
  <param name="headerFormat">Purchase dynamics for $click.name2$ $time$</param>
</module>

As a side note if you're already using Sideview Utils it's very similar but you would just use an HTML module, and the $time$ key becomes $search.timeRange.label$. It would then look like this.

<module name="HTML">
  <param name="html"><![CDATA[
    <h2>Purchase dynamics for $click.name2$ $search.timeRange.label$</h2>
  ]]></param>
</module>
0 Karma

sideview
SplunkTrust
SplunkTrust

Well you can use any token that comes from upstream, so if you have a SearchSelectLister with a 'settingToCreate' param of "foo", then you can use $foo$ to display the user's selection. Note with Sideview Utils you get an expanded vocabulary of these tokens, there's a docs page in Sideview Utils talking just about the main ones are and how to use them, and the Sideview Editor has a "Runtime Debug" mode you can use to inspect the tokens in a living view to see what values are actually coming down from upstream.

0 Karma

iKate
Builder

That's terrific! Thank you very much! I knew about this module and have already used it but in this case I just didn't guess that one can use "click.name(2)" even without preliminary stating of it.

Now it's interesting what other parameters can be fetched into headerFormat except $click.name$ and $time$?)

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

SOC4Kafka - New Kafka Connector Powered by OpenTelemetry

The new SOC4Kafka connector, built on OpenTelemetry, enables the collection of Kafka messages and forwards ...

Event Series: Level up your SOC: Advancing with Splunk Enterprise Security

AI has fundamentally raised the stakes for security operations, and this three-part series is your guide to ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...