Dashboards & Visualizations

How to get a drilldown to work on $row$ with transpose command in dashboard XML?

mrfredman
Path Finder

Hi,

I've got my dynamic drilldown setup and working properly so long as I don't include a transpose in the search string, but if a transpose is included the dynamic drilldown ceases to function.

It's setup as such in the dashboard xml:

 <drilldown target="New Window">
 <link>http://internal_link/foo/$row.id$</link>
        </drilldown>

I assume this is because after the transpose the referenced row ceases to exist. I had hoped that substituting $column.id$ would be a quick solution, but that doesn't seem to work.

Is there a way I can continue to reference the id after a transpose?

0 Karma
1 Solution

martin_mueller
SplunkTrust
SplunkTrust

Could you post your search and the rationale for using transpose as well as some sample data?

I'd hazard a guess that you can replace transpose with untable row column value | xyseries column row value, depending on what you're doing exactly of course. Then you could retain reasonable field names without the ugly column - row 1 - row 2 malarkey.

View solution in original post

martin_mueller
SplunkTrust
SplunkTrust

Could you post your search and the rationale for using transpose as well as some sample data?

I'd hazard a guess that you can replace transpose with untable row column value | xyseries column row value, depending on what you're doing exactly of course. Then you could retain reasonable field names without the ugly column - row 1 - row 2 malarkey.

mrfredman
Path Finder

Switching the transpose to an untable did the trick. Didn't need to use xyseries at all.

Thanks.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...