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!

Infographic provides the TL;DR for the 2023 Splunk Career Impact Report

We’ve been shouting it from the rooftops! The findings from the 2023 Splunk Career Impact Report showing that ...

Splunk Lantern | Getting Started with Edge Processor, Machine Learning Toolkit ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...

Enterprise Security Content Update (ESCU) | New Releases

In the last month, the Splunk Threat Research Team (STRT) has had 2 releases of new security content via the ...