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!

Improve Your Security Posture

Watch NowImprove Your Security PostureCustomers are at the center of everything we do at Splunk and security ...

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...