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

[mrfredman]

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?

[martin_mueller · Accepted solution]

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]

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

Thanks.